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 “drought” 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
drought1225888(None) 
brought13308691brought
dought114915521d_ought
draught12266981draught
droughts13245741droughts
droughty16304481droughty
wrought14276931wrought
abought1346152abought
bought125115642_bought
dough105217382d_ough_
doughs115912932d_oughs
doughty15436022d_oughty
doughy14499842d_oughy
draughts13284752draughts
draughty16233522draughty
drouth104410102drouth_
drouths11436482drouths
drouthy14395172drouthy
fought135112402_fought
fraught14266362fraught
nought104713972_nought
ought95221542__ought
rough97819442_rough_
roughs105416222_roughs
roughy137010862_roughy
sought106315062_sought
thought14639142thought
trough108512032trough_
troughs11698692troughs
aright103817663ar_ight
aught95120703__aught
besought1454003besought
borough1344523borough_
boroughs1443803boroughs
bough115719313_bough_
boughs125414373_boughs
bright124215923br_ight
brougham1642973brougham
brugh115414293br_ugh_
brughs12509063br_ughs
caught124911683_caught
chough15699253chough_
choughs16576633choughs
claught1335103claught
clough12539133clough_
cloughs13517053cloughs
cough115819643_cough_
coughs125514543_coughs
crouch133910203crouch_
delight12610673delight
dight104027003d__ight
dogfought1861793dogfought
doubt8720093d_ou_bt
douche124613223d_ouche
doughnut1343563d_oughnut
draughted1543693draughted
dreigh11246443dreigh_
driegh11254563driegh_
drogue8938333dro_gue
drogues9398393drogues
droit65127123dro__it
drongo836793drong_o
drongos935493drongos
droplet10312113droplet
droplight1643803droplight
dropout10410003dropout
dropshot1445073dropshot
dropt86924433dro__pt
droughtier1542613droughtier
drouk1039433drou__k
drouked1335543drouked
drouks1137123drou_ks
drug65718133dr_ug__
drugget10337613drugget
druggy12344743dr_uggy
drugs75214653dr_ug_s
enough1045763enough_
enoughs1144633enoughs
fraughts15214243fraughts
freight1447603freight
fright133715243fr_ight
grouch12318473grouch_
grouchy16294243grouchy
grout65330423grou__t
indraught1452473indraught
infought1543533infought
inwrought1652403inwrought
lough95118483_lough_
loughs105014773_loughs
naught104312493_naught
nougat74712653_nougat
noughts11478083_noughts
oughts104710183__oughts
plough12577563plough_
ploughs13526103ploughs
prebought17113153prebought
rebought1474403rebought
refought1564243refought
resought1254993resought
rewrought1652763rewrought
right94430503_r_ight
rotgut738793_rotgut
rouche114714313_rouche
rouge65423443_roug_e
rouged86717323_rouged
rouges76022383_rouges
roughed124210943_roughed
roughen11338833_roughen
rougher113511033_rougher
roughest1238773_roughest
roughly14507293_roughly
roupet84218343_roupet
roust55532063_rou_st
rout46153283_rou__t
routh86423073_routh_
rouths95416823_rouths
slough10539233slough_
sloughs11497563sloughs
sloughy14535803sloughy
sough95320463_sough_
soughs105115623_soughs
taught104312243_taught
though139410783though_
thoughts15515613thoughts
through141647523through_
tough97321993_tough_
toughs105414993_toughs
toughy135911083_toughy
trout57332573trou__t
unbought1443773unbought
unfought1543553unfought
unrough11105243unrough_
unsought1244243unsought
unwrought1652463unwrought
waught133811043_waught
wright133713513wr_ight

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.390458182.1
2DLD Change Limit1340271366.92319359.7
3Display Results1361360.0462956.5
 (SQL Overall)1786911367.35924282.0
 
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.