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

103 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
claught133510(None) 
caught124911681c_aught
claucht1445581claucht
claughts1443381claughts
aught95120702__aught
claughted1643242claughted
clough12539132clough_
cloughs13517052cloughs
draught12266982draught
fraught14266362fraught
laugh94414372_laugh_
laughs10489022_laughs
naught104312492_naught
taught104312232_taught
waught133811042_waught
abought1346153abought
alight103816863al_ight
alright1148853alright
aughts104710243__aughts
blight124114623bl_ight
bought125115643_bought
brought13308693brought
calumet11313293calumet
catgut9310803c_atgut
chaunt11613493chau_nt
chough15699253chough_
choughs16576633choughs
clach124617823cla_ch_
clachs133511323cla_chs
cladist10311973cladist
clag75924573cla_g__
clagged12749233clagged
clags85621123cla_g_s
clamant11312433clamant
clang86019313clang__
clanged114212653clanged
clanger104113493clanger
clangor10426683clangor
clangs95113613clang_s
clapt98027173cla__pt
claret84026573cla_ret
clash106219033cla_sh_
claspt104513413cla_spt
clast76030583cla__st
claughting1742483claughting
clausal936273clausal
clause84311503clau_se
clauses93813323clauses
clout75330463clou__t
cough115819643c_ough_
coughs125514543c_oughs
dought114915523_dought
draughts13284753draughts
draughty16233523draughty
drought12258883drought
faugh125712963_faugh_
flaunt9712913flau_nt
flight134014813fl_ight
fought135112403_fought
fraughts15214243fraughts
haugh125114053_haugh_
haughs13408563_haughs
haughty17334643_haughty
kiaugh1442813kiaugh_
kiaughs1542283kiaughs
laigh95515923_laigh_
laighs10508803_laighs
laughed1235893_laughed
laugher1136603_laugher
laughter1245113_laughter
light94429603_l_ight
lough95118483_lough_
loughs105014773_loughs
naughts11447513_naughts
naughty14445623_naughty
nought104713973_nought
onslaught13122113onslaught
ought95221543__ought
paughty16294323_paughty
plaudit1046253plaudit
plight123513363pl_ight
plough12577563plough_
ploughs13526103ploughs
retaught1244663retaught
saugh95318403_saugh_
saughs104812053_saughs
saughy13507463_saughy
shaugh13287433shaugh_
shaughs14245283shaughs
slaughter1344003slaughter
sleight11279023sleight
slight103416003sl_ight
slough10539233slough_
sloughs11497563sloughs
sloughy14535803sloughy
sought106315063_sought
thought14639143thought
uncaught1443623uncaught
untaught1243733untaught
waucht14399413_waucht
waugh125411683_waugh_
waughts14355963_waughts
wrought14276933wrought

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.406440125.6
2DLD Change Limit1340271035.92022639.7
3Display Results1031030.0333121.2
 (SQL Overall)1786911036.35928100.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.