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

102 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
draught1226698(None) 
draughts13284751draughts
draughty16233521draughty
drought12258881drought
fraught14266361fraught
aught95120702__aught
brought13308692brought
caught124911682_caught
claught1335102claught
dought114915522d_ought
draughted1543692draughted
droughts13245742droughts
droughty16304482droughty
fraughts15214242fraughts
indraught1452472indraught
naught104312492_naught
taught104312242_taught
waught133811042_waught
wrought14276932wrought
abought1346153abought
aright103817663ar_ight
aughts104710243__aughts
bought125115643_bought
bright124215923br_ight
brugh115414293br_ugh_
brughs12509063br_ughs
claucht1445583claucht
claughts1443383claughts
daughter1344503d_aughter
daunt65929083d_au_nt
daut56443563d_au__t
delight12610673delight
dight104027003d__ight
distraught1552773distraught
dough105217383d_ough_
doughs115912933d_oughs
doughty15436023d_oughty
doughy14499843d_oughy
drabbet12319573drabbet
drachm1436493dra_chm
draft95526683dra__ft
drag64825053dra_g__
dragee84415603dra_gee
dragged11379563dragged
dragger10309173dragger
draggle1056103draggle
draggy12346823dra_ggy
dragnet91211433dragnet
dragon838843dra_gon
drags75521113dra_g_s
drat56247833dra___t
draughtier1542443draughtier
draughting1642883draughting
dreigh11246443dreigh_
driegh11254563driegh_
drouth104410103drouth_
drouths11436483drouths
drouthy14395173drouthy
drug65718133dr_ug__
drugget10337613drugget
druggy12344743dr_uggy
drugs75214653dr_ug_s
faugh125712963_faugh_
fought135112403_fought
fraughted1743603fraughted
freight1447603freight
fright133715243fr_ight
haugh125114053_haugh_
haughs13408563_haughs
haughty17334643_haughty
indraughts1551483indraughts
kiaugh1442813kiaugh_
kiaughs1542283kiaughs
kraut95221403krau__t
laugh94414373_laugh_
laughs10489023_laughs
naughts11447513_naughts
naughty14445623_naughty
nought104713973_nought
ought95221543__ought
paughty16294323_paughty
retaught1244663retaught
right94430503_r_ight
rough97819443_rough_
roughs105416223_roughs
roughy137010863_roughy
saugh95318403_saugh_
saughs104812053_saughs
saughy13507463_saughy
shaugh13287433shaugh_
shaughs14245283shaughs
sought106315063_sought
straight1249183straight
thought14639143thought
trough108512033trough_
troughs11698693troughs
uncaught1443623uncaught
untaught1243733untaught
waucht14399413_waucht
waugh125411683_waugh_
waughts14355963_waughts
wright133713513wr_ight

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.390458182.1
2DLD Change Limit1340271025.87622809.2
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.29628381.7
 
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.