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 “molochs” 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.

136 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
molochs143522(None) 
moloch1356481moloch_
lochs106715512__lochs
mollahs12328282mollahs
mooch125313612mo_och_
mooches143714452mo_oches
moolahs12347382moolahs
aurochs1245983aurochs
blocks144513943_blocks
blocs95219653_bloc_s
bollocks1636503bollocks
bolos75531373bolo__s
booths115313793bo_oths
clachs133511323_clachs
cloche134312373_cloche
cloches144113713_cloches
clocks144916233_clocks
cloths115512483_cloths
colics104219903colic_s
colobus11389373colobus
cologs96517353colo_gs
colones96124433colones
colons86028683colo_ns
colonus94413443colonus
colors86622373colo_rs
colours95913443colours
conchs134714903co_nchs
cooch124916833co_och_
cooches143515833co_oches
coolths1236013coolths
dolors75115313dolo_rs
dolours8438823dolours
eoliths10318573eoliths
epochs1335813_epochs
flocks154713533_flocks
flocs105519233_floc_s
golosh1036463golosh_
goloshe1134733goloshe
goloshes1236263goloshes
gonophs1344453gonophs
hooch135813703ho_och_
hooches153812523ho_oches
kolos94921213kolo__s
loch95527133__loch_
locks115126923__locks
locos75822603__locos
locus74819993__locus
machs125722563m__achs
malices114316623malices
meloids10911453meloids
melons84117713melo_ns
milch124413373mil_ch_
milords10117853milords
milos75428013milo__s
mocha1249923m__ocha
mochas13310663m__ochas
mocks135023823m__ocks
mocs85834903m__oc_s
mojoes15399523mojo_es
mojos145314463mojo__s
molars85517323mol_ars
molas75132093mol__as
molders103315553molders
molds85324833mol__ds
moles74747923mol__es
molests93311563molests
molies84429513mol_ies
mollah11319453mollah_
mollies93420233mollies
molls75129783mol__ls
mols65948573mol___s
molters93816973molters
molts76032093mol__ts
monarchs1544833monarchs
monocle1139663monocle
monocles12310673monocles
monocot11412013monocot
monocots1249813monocots
monos75930863mono__s
months113812933mo_nths
mooched153910533mo_oched
moocher143610673mo_ocher
moochers15369123mo_ochers
moods85224623mo_o_ds
moolah11409193moolah_
moolas83615593mo_olas
mooleys1236863mooleys
mools76027173mo_o_ls
moons75331003mo_o_ns
moors74923143mo_o_rs
moos66051303mo_o__s
moots75831663mo_o_ts
mopokes1536693mopokes
morocco1343523morocco
moroccos1443813moroccos
morons84919543moro_ns
morphs13149433mo_rphs
moths106021553m__oths
motors84616603moto_rs
mouch124715803mo_uch_
mouches143815963mo_uches
mouths115214533mo_uths
mozos165516333mozo__s
mulch124012973mul_ch_
mulches143210673mul_ches
mulcts10298713mul_cts
mullahs12388733mullahs
mullocks1645033mullocks
nolos54423353nolo__s
oohs75220693_o_o_hs
ooliths10268323ooliths
oolongs845953oolongs
polices113118053polices
pollocks1656473pollocks
polos76129913polo__s
pooch124815303po_och_
pooches143214163po_oches
poohs103915713po_o_hs
relocks134411293relocks
rococos1145903rococos
rowlocks1744353rowlocks
shlocks16317183shlocks
sloths94911893_sloths
smooch13266803smo_och_
smooches15217263smo_oches
smoochy17223863smo_ochy
smooths12216323smo_oths
solaces93116133solaces
solons65120023solo_ns
solos54830793solo__s
sooths95715593so_oths
soroche1237183soroche
soroches1338803soroches
tooths96013803to_oths
unlocks1337063unlocks
volosts1036563volosts

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.420425454.8
2DLD Change Limit1340271366.51620568.9
3Display Results1361360.0632158.7
 (SQL Overall)1786911366.99925530.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.