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

214 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
waucht1439941(None) 
wauchts15285281wauchts
waught133811041waught
aught95120702_aught
caught124911682caught
claucht1445582claucht
faucet115816552faucet
gauche1238562gauche
gaucho1256222gaucho
naught104312492naught
sauch104918772sauch_
sauchs115112232sauchs
taught104312232taught
watch135617062watch_
wauchted1753372wauchted
waugh125411682waugh_
waughts14355962waughts
wecht13415442w_echt
yacht13417392ya_cht
ache96829823_a_che
achy126316093_a_chy
act59557843_a_c_t
ancho104515303_ancho
arch98628443_arch_
ascot76522513_ascot
audit62527883_audit
aughts104710243_aughts
aunt46553653_au_nt
bach116131393ba_ch_
baht96740013ba__ht
batch124620103batch_
bought125115643bought
cache125122483ca_che
cachet134526413ca_chet
cancha134411613cancha
capuche1644433capuche
catch125120373catch_
catchy16559583catchy
caucus1039613caucus
claught1335103claught
couch125320113couch_
dacha114812573da_cha
datcha1266563datcha
daunt65929083dau_nt
daut56443563dau__t
douche124613223douche
dought114915523dought
draught12266983draught
ducat86225903_ducat
duchy144310873_duchy
duct75735463_duc_t
each95530583ea_ch_
echt95722903__echt
educt85017103educ_t
eruct74022353eruc_t
facet106038523fa_cet
fact97142543fa_c_t
faucal11339963faucal
fauces114916153fauces
faucets12578443faucets
faugh125712963faugh_
fault85428313fau_lt
fought135112403fought
fraught14266363fraught
gaucher1337243gaucher
gauchest1436293gauchest
gauchos1345903gauchos
gault65128483gau_lt
gaunt65430403gau_nt
hatch135719593hatch_
hatchet153317563hatchet
haugh125114053haugh_
haughs13408563haughs
haughty17334643haughty
haunch14377343haunch_
haunt85229133hau_nt
haut75949733hau__t
heuch135312333heuch_
heuchs14447923heuchs
jaunt125025273jau_nt
kwacha1832983kwa_cha
laich105920713laich_
laichs115110893laichs
lancet84223573lancet
larch105919793larch_
latch104620463latch_
latchet123117913latchet
laugh94414373laugh_
laughs10489023laughs
launch11368063launch_
licht104723493_licht
louche115212663louche
mach116134483ma_ch_
mache125925303ma_che
macho126120153ma_cho
machs125722563ma_chs
manche133515103manche
manchet143317783manchet
march125622893march_
mascot104016073mascot
match125621103match_
maumet103518883maumet
maut65448453mau__t
mouch124715803mouch_
much115224033_much_
mucho125013443_mucho
nacho105414383na_cho
natch105018223natch_
naughts11447513naughts
naughty14445623naughty
nautch1144813nautch_
nought104713973nought
nucha10229793_nucha
ouch95724633_ouch_
ought95221543_ought
pacha126518063pa_cha
pact86648723pa_c_t
parch125123003parch_
patch125221223patch_
patchy16509573patchy
paucity1435823paucity
paughty16294323paughty
paunch13369853paunch_
paunchy17324443paunchy
pouch124617083pouch_
pouchy16538663pouchy
rachet115028973ra_chet
ranch105019793ranch_
rancho114310853rancho
ratch104221363ratch_
ratchet124218333ratchet
raucity1235853raucity
raunch11358433raunch_
raunchy15284313raunchy
rouche114714313rouche
ruche104216763_ruche
sachet114725773sa_chet
sauce75121653sauc_e
sauced93913303sauced
saucer84314103saucer
sauces84919503sauces
saucy104615163sauc_y
saugh95318403saugh_
saughs104812053saughs
saughy13507463saughy
sault55834963sau_lt
sought106315063sought
such96424813_such_
swatch14549283swatch_
tacet75840023ta_cet
tach96132753ta_ch_
tache106222373ta_che
tachs105820933ta_chs
tacit76333673ta_cit
tact67349033ta_c_t
taunt55532283tau_nt
taut47048963tau__t
teuch105214853teuch_
touch106519393touch_
touche114916173touche
touchy145010503touchy
vault85823763vau_lt
vaunt85925313vau_nt
vouch134611903vouch_
wack135330913wa_c_k
wacke145918623wa_cke
wacko145514383wa_cko
wacks146626283wa_cks
wacky174714933wa_cky
wadset10314303wadset
waft106139003wa__ft
waist86132383wa_ist
wait75553693wa__it
wallet93327093wallet
walnut939433walnut
want76156173wa__nt
warmth1477933warmth
wart77866083wa__rt
wash106033813wa_sh_
washy145911843wa_shy
wast75655853wa__st
wat67378923wa___t
watched163012823watched
watcher153113403watcher
watches153017373watches
watchout1647013watchout
watt75545413wa__tt
wauchting1843473wauchting
waughted1643483waughted
wauk115220593wau__k
wauked144210573wauked
wauks125515163wau_ks
waul76927313wau__l
wauled104713963wauled
wauls86120553wau_ls
waur76819903wau__r
wechts1446253w_echts
weight133914183weight
welch134411493welch_
wench136214783wench_
which163910083which_
whisht154510813whisht
wich125724743w_ich_
wight123725573w_ight
winch135016663winch_
witch134517563witch_
witchy17468593witchy
wright133713513wright
wrought14276933wrought
wurst85122993w_urst
wushu1136993w_ushu
wych154011883w_ych_
yachts1437023ya_chts
yuch125818533_yuch_

Search took 6 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.376475242.0
2DLD Change Limit1127162144.82623356.0
3Display Results2142140.0633396.8
 (SQL Overall)1786912145.26533939.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.