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

213 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
waught13381104(None) 
aught95120701_aught
caught124911681caught
naught104312491naught
taught104312231taught
waucht14399411waucht
waugh125411681waugh_
waughts14355961waughts
aughts104710242_aughts
bought125115642bought
claught1335102claught
dought114915522dought
draught12266982draught
faugh125712962faugh_
fought135112402fought
fraught14266362fraught
haugh125114052haugh_
haughs13408562haughs
haughty17334642haughty
laugh94414372laugh_
laughs10489022laughs
naughts11447512naughts
naughty14445622naughty
nought104713972nought
ought95221542_ought
paughty16294322paughty
saugh95318402saugh_
saughs104812052saughs
saughy13507462saughy
sought106315062sought
wauchts15285282wauchts
waughted1643482waughted
weight133914182weight
wight123725572w_ight
wright133713512wright
wrought14276932wrought
aargh96314083aargh_
abought1346153abought
agha87417303_a_gha
alight103816863alight
angst6415493_angst
argot67728653_argot
aright103817663aright
audit62527883_audit
auger64922473_auger
augite7312613_augite
augur64311213_augur
august739203_august
aunt46553653_au_nt
baguet9316103baguet
baht96740013ba__ht
bight118728843_bight
blight124114623blight
bough115719313bough_
boughs125414373boughs
bright124215923bright
brought13308693brought
brugh115414293brugh_
brughs12509063brughs
catgut9310803catgut
claucht1445583claucht
claughts1443383claughts
cough115819643cough_
coughs125514543coughs
daughter1344503daughter
daunt65929083dau_nt
daut56443563dau__t
dight104027003_dight
dough105217383dough_
doughs115912933doughs
doughty15436023doughty
doughy14499843doughy
draughts13284753draughts
draughty16233523draughty
drought12258883drought
eight94928053_eight
faggot1139053faggot
fagot9323403fa_got
faucet115816553faucet
fault85428313fau_lt
fight124027093_fight
flight134014813flight
fraughts15214243fraughts
fright133715243fright
gadget93616183gadget
garget84327273garget
gauche1238563gauche
gaucho1256223gaucho
gauge76117903gaug_e
gauged94713473gauged
gauger84714853gauger
gauges85915993gauges
gault65128483gau_lt
gaunt65430403gau_nt
haunt85229133hau_nt
haut75949733hau__t
height134713433height
heugh125410923heugh_
heughs13516903heughs
hight125327233_hight
jaunt125025273jau_nt
kiaugh1442813kiaugh_
kiaughs1542283kiaughs
knight1438173knight
laigh95515923laigh_
laighs10508803laighs
laughed1235893laughed
laugher1136603laugher
laughter1245113laughter
light94429603_light
lough95118483lough_
loughs105014773loughs
maggot10311713maggot
magot8326393ma_got
mauger93813483mauger
maugre9308973maugre
maumet103518883maumet
maut65448453mau__t
might113827083_might
night94327853_night
nougat74712653nougat
noughts11478083noughts
oughts104710183_oughts
parget94529393parget
plight123513363plight
pugh106619233_pugh_
retaught1244663retaught
right94430503_right
rough97819443rough_
roughs105416223roughs
roughy137010863roughy
sangh95517453sangh_
sanghs105312063sanghs
sauch104918773sauch_
sauchs115112233sauchs
sauger74316253sauger
sault55834963sau_lt
shaugh13287433shaugh_
shaughs14245283shaughs
sight94629293_sight
slight103416003slight
sough95320463sough_
soughs105115623soughs
sugh86423443_sugh_
sughs95313323_sughs
target75028903target
taunt55532283tau_nt
taut47048963tau__t
teugh95511613teugh_
thought14639143thought
tight93626503_tight
tough97321993tough_
toughs105414993toughs
toughy135911083toughy
ugh76520683__ugh_
ughs85410973__ughs
uncaught1443623uncaught
untaught1243733untaught
vault85823763vau_lt
vaunt85925313vau_nt
vugh117115723_vugh_
vughs12678743_vughs
wadset10314303wadset
waft106139003wa__ft
wag76451753wa_g__
wage84834083wa_g_e
waged104822783wa_ged
wager95925053wa_ger
wages95330933wa_ges
wagged124616123wagged
wagger113616013wagger
waggle113612303waggle
waggly14347293waggly
waggon1136393waggon
wagon94312953wa_gon
wags86140553wa_g_s
waist86132383wa_ist
wait75553693wa__it
wallet93327093wallet
walnut939433walnut
wangan10311223wangan
wangle103817503wangle
wangun1037103wangun
want76156173wa__nt
warmth1477933warmth
wart77866083wa__rt
wash106033813wa_sh_
washy145911843wa_shy
wast75655853wa__st
wat67378923wa___t
watch135617063watch_
watt75545413wa__tt
wauchted1753373wauchted
waughting1743123waughting
wauk115220593wau__k
wauked144210573wauked
wauks125515163wau_ks
waul76927313wau__l
wauled104713963wauled
wauls86120553wau_ls
waur76819903wau__r
wecht13415443w_echt
weigh125412513weigh_
weighs13338873weighs
weights14409553weights
weighty17376233weighty
whisht154510813whisht
widget113815263widget
wights133315783w_ights
wrights14318993wrights
wurst85122993w_urst
wushu1136993w_ushu
yacht13417393ya_cht

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162135.70319764.3
3Display Results2132130.0633381.0
 (SQL Overall)1786912136.15629027.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.