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 “thoughts” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
thoughts1551561(None) 
thought14639141thought_
choughs16576632chough_s
droughts13245742droughts
noughts11478082_noughts
oughts104710182__oughts
though139410782though__
toughs105414992t_ough_s
troughs11698692trough_s
abought1346153abought_
aughts104710243__aughts
bethought1853443bethought_
boughs125414373_bough_s
bought125115643_bought_
brought13308693brought_
chough15699253chough__
choushes1637623choushes
claughts1443383claughts
cloughs13517053clough_s
coughs125514543_cough_s
doughs115912933_dough_s
dought114915523_dought_
doughty15436023_doughty
draughts13284753draughts
drought12258883drought_
droughty16304483droughty
enoughs1144633enough_s
fought135112403_fought_
fraughts15214243fraughts
haughs13408563_haugh_s
haughty17334643_haughty
heights14399443_heights
heughs13516903_heugh_s
hights133716893_h_ights
hoggets12498323_hoggets
loughs105014773_lough_s
methought1853943methought_
naughts11447513_naughts
nougats8427413_nougats
nought104713973_nought_
ought95221543__ought_
ploughs13526103plough_s
rethought1653813rethought_
roughs105416223_rough_s
shaughs14245283shaugh_s
sheughs14264533sheugh_s
shouts94017723shou__ts
sloughs11497563slough_s
soughs105115623_sough_s
sought106315063_sought_
taught104312233t_aught_
thighs1346633th_igh_s
thongs104611193thong__s
thoughtful2051543thoughtful
thoughtless1851693thoughtless
thoughtway2351213thoughtway
thoughtways246953thoughtways
thous86017263thou___s
through141647523through__
throughly1952433throughly
throughputs2061533throughputs
thruputs1341963thruputs
thrushes1436523thrushes
thrusts10226523thru_sts
thugs95611993th_ug__s
tights104015853t__ights
tonights1244593tonights
touches125118343t_ouches
tough97321993t_ough__
toughed123511693t_oughed
toughen11329203t_oughen
toughens12286723t_oughens
tougher114210983t_ougher
toughest1238303t_oughest
toughie1187593t_oughie
toughies1278243t_oughies
toughish1545283t_oughish
toughly14487433t_oughly
toughy135911083t_ough_y
touts54830393t_ou__ts
trough108512033trough__
trouts66116633trou__ts
unthought1652863unthought_
waughts14355963_waughts
wrought14276933wrought_

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 Filter1786911461620.420425454.8
2DLD Change Limit146162856.56322270.6
3Display Results85850.0332575.8
 (SQL Overall)178691857.01625469.1
 
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.