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

143 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
brought1330868(None) 
bought125115631b_ought
drought12258871drought
wrought14276921wrought
abought1346142abought
besought1453992besought
borough1344512borough_
boroughs1443792boroughs
bough115719312b_ough_
boughs125414372b_oughs
bright124215922br_ight
brougham1642972brougham
brugh115414292br_ugh_
brughs12509062br_ughs
dought114915512_dought
draught12266962draught
droughts13245732droughts
droughty16304472droughty
fought135112392_fought
fraught14266352fraught
nought104713962_nought
ought95221532__ought
rough97819432_rough_
roughs105416212_roughs
roughy137010852_roughy
sought106315052_sought
thought14639132thought
trough108512022trough_
troughs11698682troughs
aright103817663ar_ight
aught95120703__aught
barouche1544173barouche
bedight1437483bedight
berouged1235323berouged
bethought1853433bethought
bight118728843b__ight
blight124114623b_light
borscht1445993borscht
borsht11813503b_orsht
boughed143810263b_oughed
boughpot1643503b_oughpot
boughten1444193b_oughten
bougie93613273b_ougie
bout66353293b_ou__t
brights133710233br_ights
broach133611113broach_
broche133612103bro_che
brocket154013383brocket
brogan9311043bro_gan
brogue94211033bro_gue
brogues10719823brogues
bronchi14176313bronchi
broncho14206463broncho
brooch13368443brooch_
broth106521093bro_th_
broths115013923bro_ths
brothy14519623bro_thy
broughams1742403broughams
brouhaha1641463brouhaha
bruit76126723br_u_it
brulot8912213br_ulot
brunet84419293br_unet
brunt75728753br_u_nt
brush105917473br_ush_
brushy14468263br_ushy
brut66537963br_u__t
caught124911683_caught
chough15699243chough_
choughs16576623choughs
claught1335103claught
clough12539133clough_
cloughs13517053cloughs
cough115819643_cough_
coughs125514543_coughs
crouch133910203crouch_
dough105217383_dough_
doughs115912933_doughs
doughty15436023_doughty
doughy14499843_doughy
draughts13284753draughts
draughty16233523draughty
drouth104410103drouth_
drouths11436483drouths
drouthy14395173drouthy
enough1045753enough_
enoughs1144623enoughs
fraughts15214243fraughts
freight1447603freight
fright133715243fr_ight
grouch12318473grouch_
grouchy16294243grouchy
grout65330423grou__t
infought1543523infought
inwrought1652393inwrought
lough95118483_lough_
loughs105014773_loughs
naught104312493_naught
nougat74712653_nougat
noughts11478083_noughts
oughts104710183__oughts
plough12577563plough_
ploughs13526103ploughs
prebought17113143prebought
rebought1474393rebought
refought1564233refought
resought1254983resought
rewrought1652753rewrought
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
taught104312223_taught
though139410773though_
thoughts15515603thoughts
through141647513through_
tough97321983_tough_
toughs105414983_toughs
toughy135911073_toughy
trout57332573trou__t
unbought1443763unbought
unfought1543543unfought
unrough11105233unrough_
unsought1244233unsought
unwrought1652453unwrought
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.393454684.5
2DLD Change Limit1340271436.61020276.4
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.04925349.8
 
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.