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
thought1463914(None) 
though139410781though_
thoughts15515611thoughts
abought1346152abought
bethought1853442bethought
bought125115642_bought
brought13308692brought
chough15699252chough_
choughs16576632choughs
dought114915522_dought
drought12258882drought
fought135112402_fought
methought1853942methought
nought104713972_nought
ought95221542__ought
rethought1653812rethought
sought106315062_sought
taught104312232t_aught
through141647522through_
tough97321992t_ough_
toughs105414992t_oughs
toughy135911082t_oughy
trough108512032trough_
troughs11698692troughs
unthought1652862unthought
wrought14276932wrought
although1542603although_
aught95120703__aught
besought1454003besought
bough115719313_bough_
boughs125414373_boughs
caught124911683_caught
choush14549063choush_
claught1335103claught
clough12539133clough_
cloughs13517053cloughs
cough115819643_cough_
coughs125514543_coughs
dough105217383_dough_
doughs115912933_doughs
doughty15436023_doughty
doughy14499843_doughy
draught12266983draught
droughts13245743droughts
droughty16304483droughty
enough1045763enough_
enoughs1144633enoughs
fraught14266363fraught
haugh125114053_haugh_
haughs13408563_haughs
haughty17334643_haughty
height134713433_height
heugh125410923_heugh_
heughs13516903_heughs
hight125327233_h_ight
hogget114715763_hogget
infought1543533infought
lough95118483_lough_
loughs105014773_loughs
misthought1952263misthought
naught104312493_naught
nougat74712653_nougat
noughts11478083_noughts
oughts104710183__oughts
outbought1544013outbought
outfought1643763outfought
outthought1752313outthought
plough12577563plough_
ploughs13526103ploughs
rebought1474403rebought
refought1564243refought
resought1254993resought
rough97819443_rough_
roughs105416223_roughs
roughy137010863_roughy
shaugh13287433shaugh_
shaughs14245283shaughs
sheugh13295883sheugh_
sheughs14264533sheughs
shout85433173shou__t
slough10539233slough_
sloughs11497563sloughs
sloughy14535803sloughy
sough95320463_sough_
soughs105115623_soughs
teugh95511613t_eugh_
thigh12410123th_igh_
thighs1346633th_ighs
thong95014183thong__
thonged12376843thonged
thongs104611193thong_s
thorough15684133thorough_
thou76722213thou___
thoued10429003thou_ed
thoughtful2051543thoughtful
thoughtway2351213thoughtway
thouing11258603thouing
thous86017263thou__s
throughly1952433throughly
throughout1753033throughout
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
unbought1443773unbought
unfought1543553unfought
unsought1244243unsought
waught133811043_waught

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.420425454.8
2DLD Change Limit1340271236.34321129.9
3Display Results1231230.0462673.9
 (SQL Overall)1786911236.80926243.4
 
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.