Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “hognose” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
hognose1111724(None) 
hognoses12108141hognoses
cognise1059682cognise
hooknose1544272hooknose
prognose1146462prognose
acinose938583acinose
agonise83112693agonise
anginose945903anginose
arenose7311383arenose
bongoes104314113bongoes
bongos95316653bongos_
choose115116143cho__ose
cognate10312203cognate
cognised1256313cognised
cognises11610043cognises
cognize1957683cognize
cognomen1346083cognomen
cogons96818113cogons_
comose105016853co_mose
compose135716663compose
conenose1078593conenose
congoes103617303congoes
congos94219883congos_
connote9311613connote
diagnose1045123diagnose
doggone1035683doggone
doghouse1345413doghouse
foliose10378013foliose
geognosy1341203geognosy
gnome84213953__gnome
gnoses76515163__gnoses
gogos77516523gog_os_
goose65925903__goose
hagrode1236453hagrode
hanse85722793h_an_se
hardnose1245723hardnose
hawknose1842323hawknose
heptose1237493heptose
hexose16267843h_exose
hoarse94411323ho_arse
hobnob1335133hobno_b
hobnobs1443603hobnobs
hoboes114717453ho_boes
hobos106321353ho_bos_
hogans105914313hogans_
hogfish17257023hogfish
hoggish15247593hoggish
hoggs107212463hog_gs_
hoglike15157733hoglike
hogmane1336343hogmane
hognut1039413hogn_ut
hognuts1134183hognuts
hogs87139663hog__s_
hogtie102711773hog_tie
hogties112813993hogties
hogwash1742713hogwash
hoise85224773ho__ise
holloes103818193holloes
hollos95320633hollos_
hommos13128503hommos_
hommoses1538163hommoses
homos105921793ho_mos_
homosex1936133ho_mosex
hondle103914523ho_ndle
hone77549323ho_n__e
hones88144493ho_nes_
honest94822423ho_nest
hongies112716473hongies
hongs95126203ho_ngs_
honkie133011673ho_nkie
honks125124523ho_nks_
honor85718623ho_no_r
honored11310123ho_nored
honoree10412113ho_noree
honorer1039673ho_norer
honors94816793ho_nors
honour94710863ho_nour
hons77350783ho_n_s_
hooknosed1742413hooknosed
hooknoses1644353hooknoses
hoopoe11911233hoopo_e
hoopoes121212483hoopoes
hormone12410503hormone
hornist102314823hornist
horns86125333horn_s_
horse86132653ho__rse
hose76547243h___ose
hothouse1447353hothouse
hotness1038613hotness
hounds104413133hounds_
house89131423ho__use
hypnoses1646633hypnoses
ignore7269063_ignore
ionise63516943io_nise
ionone6313443io_none
jocose1537103jo_cose
lanose6313593_lanose
logons79818173logons_
logos67225333log_os_
loose56627683lo__ose
mannose939243mannose
mongoe94214983mongo_e
mongoes103415713mongoes
mongoose1175353mongoose
mongos94318623mongos_
monos75930863mo_nos_
moose76327193mo__ose
morose85116243mo_rose
nodose738883no_dose
nonuse63212253no_nuse
noose55624063no__ose
nose46739363___nose
onos46229003_o_nos_
oppose1039193_oppose
osmose8108003_osmose
otiose639403_otiose
phonos114114793pho_nos_
pornos85015253pornos_
porose84818743po_rose
prognosed1344533prognosed
prognoses1247533prognoses
rhamnose13103463rhamnose
roose56127093ro__ose
rugose737283rug_ose
segnos73610443segnos_
signore8329093signore
sorbose938983sorbose
spinose937943spinose
torose64317693to_rose
urinose738483urinose
venose9310843_venose
zoonoses1746203zoonoses
zygose19455553zyg_ose

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271337.12618808.2
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.57823580.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.