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

379 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
drouth10441010(None) 
drouths11436481drouths
drouthy14395171drouthy
routh86423071_routh
broth106521092bro_th
couth106122492_couth
crouch133910202crouch
croute84617272croute
doeth9411982d_oeth
doth86225712d_o_th
dough105217382d_ough
droit65127122droit_
droits74314312droits
dropt86924432dropt_
drought12258872drought
drouk1039432drou_k
drouks1137122drouks
froth115919282fro_th
grouch12318472grouch
grout65330422grout_
grouts75015612grouts
grouty104710982grouty
growth1377382growth
mouth105420292_mouth
rough97819432_rough
rout46153282_rout_
route55132072_route
rouths95416822_rouths
routs57133412_routs
rowth115713232_rowth
ruth76825992_r_uth
scouth115011152scouth
south85223572_south
troth85622202tro_th
trough108512022trough
trout57332572trout_
trouts66116632trouts
trouty95211792trouty
trowth1277882trowth
truth85214152tr_uth
wroth116815882wro_th
youth115315042_youth
about75229083about_
adroit7518793adroit_
agouti7388773agouti
agouty10366913agouty
arbute8311043arbute
around72712413around
arouse65019983arouse
avouch1434833avouch
azoth17389903azo_th
badmouth1643583badmouth
booth105522013_booth
borough1344513borough
both96533433_bo_th
bough115719313_bough
bout66353293_bout_
bouts75131313_bouts
breath113916263breath
brith104924373br_ith
broach133611113broach
brooch13368443brooch
broths115013923bro_ths
brothy14519623bro_thy
brought13308683brought
brugh115414293br_ugh
brush105917473br_ush
brut66537963br_ut_
brute75321783br_ute
bruts75922953br_uts
chough15699243chough
choush14549063choush
cloth105817543clo_th
clough12539133clough
clout75330463clout_
clouts87017203clouts
coolth1139513coolth
couch125320113_couch
cough115819643_cough
couths115715413_couths
croft105622683croft_
crofts114910593crofts
crotch133410083crotch
croup95616783crou_p
croupe105114433croupe
croups104312553croups
croupy13458733croupy
crouse84619363crouse
croutes94815653croutes
crouton947133crouton
crush106815993cr_ush
crutch13408243cr_utch
crwth1337483cr_wth
daleth1038633daleth
daut56443563d_aut_
dauts67822243d_auts
dearth104212513dearth
death94822523d_eath
debouch15124253debouch
debut86024143debut_
debuts93911753debuts
depth114311853d_epth
depute94512303depute
deputy12426713deputy
devout10712993devout_
dhooti1035663dhooti
dhoti9310123dho_ti
dhuti937543d_huti
dilute72911803dilute
dimout9414243dimout_
dimouts1037893dimouts
doat56947673d_oat_
doats65224883d_oats
doit56347853d_oit_
doits66223673d_oits
dolt56649423d_olt_
dolts65626313d_olts
donut6324513donut_
donuts7410583donuts
dorty96220813d_orty
dost57248353d_ost_
dot47573183d_o_t_
dote55442883d_o_te
dots55647663d_o_ts
dotty94516103d_otty
doty86128223d_o_ty
doubt8720093d_oubt
doubts968733d_oubts
douce85518423d_ouce
douche124613223d_ouche
doughs115912933d_oughs
dought114915513d_ought
doughy14499843d_oughy
doula65717773d_oula
doum76226673d_ou_m
douma85817703d_ouma
doums85417643d_oums
dour56330433d_ou_r
doura66518663d_oura
dourah10479813d_ourah
douse66329723d_ouse
doux125817983d_ou_x
draft95526683draft_
drafts105012533drafts
drafty13638933drafty
drat56247833dr_at_
drats66628373dr_ats
draught12266963draught
dreich12377723dreich
dreigh11246443dreigh
drench12369593drench
drest65530343drest_
driegh11254563driegh
drift95722843drift_
drifts10499893drifts
drifty13418223drifty
dript86923873dript_
drogue8938333drogue
drogues9398393drogues
droid74218543dro_id
droids84712583droids
droll65415403dro_ll
drolls75312393drolls
drolly105411673drolly
dromon939363dromon
drone65324983dro_ne
droned84616863droned
droner74717673droner
drones75023433drones
drongo836793drongo
dronish1138913dronish
drool65416103dro_ol
drools74412813drools
drooly104911073drooly
droop85814823dro_op
droops95110963droops
droopy12458243droopy
drop75324403dro__p
dropout10410003dropout_
dropouts1145003dropouts
drops85719503dro_ps
dropsy12497473dropsy
drosky14486163drosky
dross65418093dro_ss
drossy10528473drossy
droughts13245733droughts
droughty16304473droughty
drouked1335543drouked
drouthier1343033drouthier
drove95518063dro_ve
droved114611643droved
drover104614593drover
droves105116673droves
drown95515823dro_wn
drownd11478313drownd
drowns105612333drowns
drowse105010553drowse
drowsy13487903drowsy
drub75920133dr_u_b
drubs85913833dr_ubs
drug65718133dr_u_g
drugs75214653dr_ugs
druid74111323dr_uid
drum76521593dr_u_m
drums85415873dr_ums
drunk10549843dr_unk
drupe85012993dr_upe
druse64817663dr_use
dryish1336323dryish
dugout8310363dugout_
dugouts935043dugouts
duh77930383d__u_h
dutch114713823d__utch
duty85321453d__uty
enough1045753enough
flout86226203flout_
flouts94315273flouts
forth116222673_forth
fourth12357443_fourth
frith115922033fr_ith
front85029223front_
fronts94415793fronts
frosh115713403fro_sh
frost84727833frost_
frosts94214623frosts
frosty124710633frosty
froths125411443fro_ths
frothy15578373fro_thy
frouzy21395283frouzy
glout65925813glout_
glouts74414713glouts
goth86825083_go_th
gout56646003_gout_
gouts64826173_gouts
gouty95217363_gouty
grith95520373gr_ith
groat65531973groat_
groats74816653groats
grot55942053gro_t_
grots65025853gro_ts
grotto7349813grotto
grotty10389833grotty
grouchy16294243grouchy
ground82310273ground
group85413923grou_p
groups94210513groups
grouse74315023grouse
grouted94111503grouted
grouter84412523grouter
growths1494423growths
growthy1773283growthy
grutch12285563gr_utch
knout95018263knout_
knouts10438313knouts
kraut95221403kraut_
krauts10418513krauts
liroth938383liro_th
loath84918603_loath
loth76132133_lo_th
lough95118483_lough
lout45952143_lout_
louts56330273_louts
month104818423_month
moth96731333_mo_th
mouch124715803_mouch
mouths115214533_mouths
mouthy14409063_mouthy
north86018273_north
oath76132153__oath
ouch95724633__ouch
ouph95618373__ouph
out38072153__out_
outs45746963__outs
plough12577563plough
pouch124617083_pouch
pout65752553_pout_
pouts75530323_pouts
pouty107018813_pouty
pronto8313993pronto
prost75434103prost_
proud84615483prou_d
pruta7314243pr_uta
prutah1136583pr_utah
quoth173310353quo_th
rath76037663_r_ath
reroute7313963reroute
roach105717003_roach
root45655923_root_
roots55933673_roots
rooty86423023_rooty
rot37282953_ro_t_
rota45834343_ro_ta
rotch105815933_rotch
rote46249023_ro_te
roti46332933_ro_ti
rotl45029683_ro_tl
roto45935053_ro_to
rots46454093_ro_ts
rotte54625933_rotte
rouche114714313_rouche
roue45941743_rou_e
rouen54920903_rouen
roues56039353_roues
rouge65423443_rouge
roughs105416213_roughs
roughy137010853_roughy
round64318433_round
roup66627693_rou_p
roups75118903_roups
roupy106112713_roupy
rouse56634703_rouse
roust55532063_roust
rousts617016723_rousts
routed75624333_routed
router65025843_router
routes66129313_routes
roux117419363_rou_x
rowths12458173_rowths
rush76628183_r_ush
rut35560523_r_ut_
ruths85714643_r_uths
ruts44541493_r_uts
scout75031453scout_
scouths12527893scouths
scouts84817943scouts
shout85433173shout_
shouts94017723shouts
sleuth937233sleuth
sloth85019453slo_th
slouch11438523slouch
slough10539233slough
smooth11259203smooth
snout54530633snout_
snouts64915873snouts
snouty9419953snouty
sooth85924063_sooth
soth75932523_so_th
sough95320463_sough
souths95216603_souths
spout75029633spout_
spouts85115113spouts
sprout8419403sprout_
sprouts949983sprouts
stout57434053stout_
stouts65019003stouts
though139410773though
through141647513through
tooth88020183_tooth
toroth95512963toroth
touch106519393_touch
tough97321983_tough
tout46753823_tout_
touts54830393_touts
trot46351313tro_t_
troths95414153tro_ths
trots56629943tro_ts
troughs11698683troughs
troupe84812433troupe
trowths1365023trowths
truths9449503tr_uths
tryout9410753tryout_
tryouts1035313tryouts
uncouth1247173uncouth
unrough11105233unrough
urolith1048783urolith
vermouth1643763vermouth
vermuth1543533vermuth
vouch134611903_vouch
vrouw11507343vrou_w
vrouws12494743vrouws
warmouth1644143warmouth
worth117120523_worth
wraith1258603wraith
wrath115715873wr_ath
wreath124111193wreath
wrote84717483wro_te
wrought14276923wrought
youths124510043_youths
zeroth1837963zero_th

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 Filter1786911127160.1261418182.5
2DLD Change Limit1127163795.73319660.9
3Display Results3793790.1103445.5
 (SQL Overall)1786913795.96929936.5
 
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.