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

123 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
thought1463913(None) 
though139410771though_
thoughts15515601thoughts
abought1346142abought
bethought1853432bethought
bought125115632_bought
brought13308682brought
chough15699242chough_
choughs16576622choughs
dought114915512_dought
drought12258872drought
fought135112392_fought
methought1853932methought
nought104713962_nought
ought95221532__ought
rethought1653802rethought
sought106315052_sought
taught104312222t_aught
through141647512through_
tough97321982t_ough_
toughs105414982t_oughs
toughy135911072t_oughy
trough108512022trough_
troughs11698682troughs
unthought1652852unthought
wrought14276922wrought
although1542593although_
aught95120703__aught
besought1453993besought
bough115719313_bough_
boughs125414373_boughs
caught124911683_caught
choush14549063choush_
claught1335103claught
clough12539133clough_
cloughs13517053cloughs
cough115819643_cough_
coughs125514543_coughs
dough105217383_dough_
doughs115912933_doughs
doughty15436023_doughty
doughy14499843_doughy
draught12266963draught
droughts13245733droughts
droughty16304473droughty
enough1045753enough_
enoughs1144623enoughs
fraught14266353fraught
haugh125114053_haugh_
haughs13408563_haughs
haughty17334643_haughty
height134713433_height
heugh125410923_heugh_
heughs13516903_heughs
hight125327233_h_ight
hogget114715763_hogget
infought1543523infought
lough95118483_lough_
loughs105014773_loughs
misthought1952253misthought
naught104312493_naught
nougat74712653_nougat
noughts11478083_noughts
oughts104710183__oughts
outbought1544003outbought
outfought1643753outfought
outthought1752303outthought
plough12577563plough_
ploughs13526103ploughs
rebought1474393rebought
refought1564233refought
resought1254983resought
rough97819433_rough_
roughs105416213_roughs
roughy137010853_roughy
shaugh13287433shaugh_
shaughs14245283shaughs
sheugh13295883sheugh_
sheughs14264533sheughs
shout85433173shou__t
slough10539233slough_
sloughs11497563sloughs
sloughy14535803sloughy
sough95320463_sough_
soughs105115623_soughs
teugh95511613t_eugh_
thigh12410123th_igh_
thighs1346633th_ighs
thong95014183thong__
thonged12376843thonged
thongs104611193thong_s
thorough15684123thorough_
thou76722213thou___
thoued10429003thou_ed
thoughtful2051543thoughtful
thoughtway2351213thoughtway
thouing11258603thouing
thous86017263thou__s
throughly1952433throughly
throughout1753023throughout
throughput1952123throughput
thruput1243863thruput
thrush12257483thrush_
thrust91911893thru_st
thug86415483th_ug__
thugs95611993th_ug_s
tight93626503t__ight
tonight1138743tonight
touch106519393t_ouch_
touche114916173t_ouche
touchy145010503t_ouchy
toughed123511693t_oughed
toughen11329203t_oughen
tougher114210983t_ougher
toughest1238303t_oughest
toughie1187593t_oughie
toughly14487433t_oughly
tout46753823t_ou__t
trout57332573trou__t
unbought1443763unbought
unfought1543543unfought
unsought1244233unsought
waught133811043_waught

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.436409841.7
2DLD Change Limit1340271237.15618729.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.63823395.0
 
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.