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

246 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
drouths1143648(None) 
drouth104410101drouth_
drouthy14395171drouthy
rouths95416821_rouths
broths115013922bro_ths
couths115715412_couths
croutes94815652croutes
doughs115912932d_oughs
droits74314312droit_s
drought12258872drought
droughts13245732droughts
drouks1137122drou_ks
froths125411442fro_ths
grouts75015612grout_s
growths1494422growths
mouths115214532_mouths
roughs105416212_roughs
routes66129312_routes
routh86423072_routh_
routs57133412_rout_s
rowths12458172_rowths
ruths85714642_r_uths
scouths12527892scouths
souths95216602_souths
troths95414152tro_ths
troughs11698682troughs
trouts66116632trout_s
trowths1365022trowths
truths9449502tr_uths
youths124510042_youths
agoutis8286873agoutis
arbutes939703arbutes
arbutus944843arbutus
arouses74921293arouses
azoths18366203azo_ths
badmouths1742443badmouths
booths115313793_booths
boroughs1443793boroughs
boughs125414373_boughs
bouts75131313_bout_s
breaths124411183breaths
briths115113863br_iths
broth106521093bro_th_
brothy14519623bro_thy
brought13308683brought
brughs12509063br_ughs
brutes86118683br_utes
bruts75922953br_ut_s
choughs16576623choughs
cloths115512483clo_ths
cloughs13517053cloughs
clouts87017203clout_s
coolths1236013coolths
coughs125514543_coughs
couth106122493_couth_
crofts114910593croft_s
crouch133910203crouch_
crouches153711293crouches
croupes114613103croupes
croups104312553crou_ps
croute84617273crout_e
crouton947133crouton
croutons1036753croutons
crwths1433433cr_wths
daleths1135323daleths
dauts67822243d_aut_s
dearths11498843dearths
deaths105914443d_eaths
debuts93911753debut_s
depths12428573d_epths
deputes104911783deputes
dhootis1135683dhootis
dhotis1038973dho_tis
dhutis1035943d_hutis
dilutes82911973dilutes
dimouts1037893dimout_s
doats65224883d_oat_s
doeth9411983d_oeth_
doits66223673d_oit_s
dolts65626313d_olt_s
donuts7410583donut_s
dotes65836693d_o_tes
doth86225713d_o_th_
dots55647663d_o_t_s
doubts968733d_oubts
douche124613223d_ouche
douches134315233d_ouches
dough105217383d_ough_
dought114915513d_ought
doughy14499843d_oughy
doulas75114993d_oulas
doumas95314813d_oumas
doums85417643d_ou_ms
dourahs11487253d_ourahs
douras75016723d_ouras
douses74928933d_ouses
drafts105012533draft_s
drats66628373dr_at_s
draught12266963draught
draughts13284753draughts
drifts10499893drift_s
drogues9398393drogues
droids84712583dro_ids
droit65127123droit__
drolls75312393dro_lls
dromons1038193dromons
droners84114383droners
drones75023433dro_nes
drongos935493drongos
dronish1138913dronish
drools74412813dro_ols
droops95110963dro_ops
dropouts1145003dropout_s
drops85719503dro__ps
dropt86924433dropt__
dross65418093dro__ss
drosses84513823drosses
droughty16304473droughty
drouk1039433drou__k
drouked1335543drouked
drouthier1343033drouthier
drouthiest1443913drouthiest
drovers115212643drovers
droves105116673dro_ves
drownds12346153drownds
drowns105612333dro_wns
drowses114610233drowses
drubs85913833dr_u_bs
drugs75214653dr_u_gs
druids8368093dr_uids
drums85415873dr_u_ms
drunks11427513dr_unks
drupes94912653dr_upes
druses75517253dr_uses
druthers1275793dr_uthers
dugouts935043dugout_s
enoughs1144623enoughs
flouts94315273flout_s
fourths13374953_fourths
friths124313583fr_iths
frontes104214163frontes
fronts94415793front_s
frosts94214623frost_s
froth115919283fro_th_
frothy15578373fro_thy
glouts74414713glout_s
goths96513003_go_ths
gouts64826173_gout_s
griths105211653gr_iths
groats74816653groat_s
grots65025853gro_t_s
grottos8337333grottos
grouch12318473grouch_
grouches14328213grouches
grouchy16294243grouchy
grounds9228313grounds
groups94210513grou_ps
grouses84616543grouses
grout65330423grout__
grouted94111503grouted
grouter84412523grouter
grouters95910083grouters
grouty104710983grout_y
growth1377383growth_
growthy1773283growthy
knouts10438313knout_s
krauts10418513kraut_s
loughs105014773_loughs
louts56330273_lout_s
months113812933_months
moths106021553_mo_ths
mouth105420293_mouth_
mouthy14409063_mouthy
norths96812323_norths
oaths86117313__oaths
ouphs104311273__ouphs
outs45746963__out_s
ploughs13526103ploughs
pouts75530323_pout_s
reroutes8312223reroutes
roots55933673_root_s
rotas54827723_ro_tas
rotes56143903_ro_tes
rotis56327063_ro_tis
rotls55620163_ro_tls
rotos56027883_ro_tos
rots46454093_ro_t_s
rottes64524833_rottes
rouche114714313_rouche
rouches124217893_rouches
rouens64814443_rouens
roues56039353_rou_es
rouges76022383_rouges
rough97819433_rough_
roughy137010853_roughy
rounds73615623_rounds
roups75118903_rou_ps
rouses65436283_rouses
rousts617016723_rousts
rout46153283_rout__
route55132073_rout_e
routed75624333_routed
router65025843_router
routers74822873_routers
rowth115713233_rowth_
ruth76825993_r_uth_
ruts44541493_r_ut_s
scouth115011153scouth_
scouts84817943scout_s
shouts94017723shout_s
sleuths1034743sleuths
sloths94911893slo_ths
sloughs11497563sloughs
smooths12216323smooths
snouts64915873snout_s
sooths95715593_sooths
soths86218633_so_ths
soughs105115623_soughs
south85223573_south_
spouts85115113spout_s
sprouts949983sprout_s
stouts65019003stout_s
tooths96013803_tooths
toughs105414983_toughs
touts54830393_tout_s
troth85622203tro_th_
trots56629943tro_t_s
trough108512023trough_
troupes94112853troupes
trout57332573trout__
trouty95211793trout_y
trowth1277883trowth_
truth85214153tr_uth_
tryouts1035313tryout_s
uroliths1154923uroliths
vermouths1742783vermouths
vermuths1642603vermuths
vrouws12494743vrou_ws
warmouths1742853warmouths
worths127812893_worths
wraiths1355033wraiths
wraths123810083wr_aths
wreaths13338373wreaths
wroth116815883wro_th_
wrought14276923wrought
youth115315043_youth_

Search took 7 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.410435831.7
2DLD Change Limit1340272465.90322704.9
3Display Results2462460.0803075.0
 (SQL Overall)1786912466.39327951.0
 
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.