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

469 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
yachts143702(None) 
yacht13417391yacht_
aches106132292_aches
acts66929862_ac_ts
baches135426942baches
bahts105617802ba_hts
caches137926912caches
cachets145014262cachets
dachas124113252dachas
facets116316652facets
facts107021892fac_ts
laches116528342laches
lichts113712382lichts
maches134827232maches
machos135217492machos
machs125722562mach_s
nachas114914192nachas
naches114622412naches
nachos115014182nachos
pachas135017142pachas
pacts95125802pac_ts
rachets124516832rachets
rachis114017652rachis
sachets123914102sachets
taches114224172taches
tachs105820932tach_s
tacts76524122tac_ts
wauchts15285282wauchts
wechts1446252wechts
yachted1634852yachted
yachter1534912yachter
yachters1633882yachters
yacks144419812yac_ks
yechs136112582yech_s
aahs716428563_aah_s
abets75621673_abets
abuts75417073_abuts
aces67645093_ac_es
aceta74017353_aceta
ache96829823_ach_e
ached119227833_ached
achoo10315083_achoo
achy126316093_ach_y
acids87121003_acids
acmes96020653_acmes
acnes75922623_acnes
acres76327763_acres
act59557843_ac_t_
acta69524803_ac_ta
acute74720363_acute
acutes83917723_acutes
acyls104211523_acyls
adits66523713_adits
aghas97014873_aghas
ahis76135383_a_his
ahs68644823_a_h_s
airts55626343_airts
aits46355533_a_its
alts46639903_a_lts
anchos114214893anchos
ants47243473_a_nts
apaches143411833apaches
aphis105917133_aphis
arches114822043arches
arhats9312973_arhats
arts49650263_a_rts
ascots85312513ascots
ashes86230613_ashes
aughts104710243aughts
aunts55227633_aunts
ayahs116813523ayah_s
bach116131393bach__
bached145519893bached
backs135729623bac_ks
bacons104917583bacons
baht96740013ba_ht_
baits76630583ba_its
bashes115631393bashes
basts75936933ba_sts
batches144019613batches
bathes116524833bathes
bathos116215633bathos
baths105922923bath_s
bats66962333ba__ts
batts76727563ba_tts
beaches144120653beaches
bights124417963bights
boches134618523boches
braches144621223braches
brachets154311983brachets
brachs134415753brach_s
bracts105617773brac_ts
cacaos104616183cacaos
cacas95627983cac_as
cache125122483cach_e
cached145419203cached
cachet134526413cachet
cachou13310613cachou
cachous14312563cachous
cacti9318633cac_ti
cactus104912233cactus
cadets96316503cadets
canchas143212403canchas
cants77036943ca_nts
caphs124515373caph_s
carats85929023carats
carets85330773carets
carts78946293ca_rts
cashes114729883cashes
casts77237793ca_sts
catches144320763catches
cats66356343__cats
chats105730093__chats
chis95933313__chis
chits105424573__chits
clachs133511323clach_s
coaches144018693coaches
coacts105314323coac_ts
cots68054843__cots
cuts65841153__cuts
daces85030683dac_es
dacha114812573dach_a
dacite91115883dacite
dacites101114593dacites
dacoits1079073dacoits
dahls95012283da_hls
dahs88231813da_h_s
darts67635733da_rts
dashes106124983dashes
dashis104414393dashis
datchas1347423datchas
daunts75014083daunts
dauts67822243da_uts
davits104012363davits
dawts97216123da_wts
dicots94915793dicots
dights114016963dights
drachms1534253drachms
ducats95011763ducats
ducts85319893duc_ts
each95530583each__
earths95014593earths
easts57530323ea_sts
eats47054873ea__ts
eches106322163_eches
echos105216463_echos
echt95722903_echt_
eights103618983eights
enacts84012973enac_ts
epacts105010393epac_ts
escots84211743escots
etches114217763etches
exacts15359613exac_ts
facers115519443facers
faces106439433fac_es
facet106038523facet_
facete115014833facete
facias113415803facias
facies113921593facies
fact97142543fac_t_
fagots1039963fagots
faints94818783faints
faiths124610273faiths
farts88336843fa_rts
fashes124524023fashes
fasts86429683fa_sts
fats76252503fa__ts
faucets12578443faucets
faults94513553faults
fiches145219533fiches
fichus14388113fichus
fights133816553fights
gaits65726013ga_its
gamuts958783gamuts
garths104111503garths
gashes105725153gashes
gasts66628633ga_sts
gats56753443ga__ts
gauchos1345893gauchos
gaults74112783gaults
gavots1038103gavots
habits113014643habits
haceks15447863haceks
hacks144928713hac_ks
haets86525123ha_ets
hafts116219463ha_fts
hahas117118443ha_has
hahs108333363ha_h_s
haints94417583haints
halts85230103ha_lts
hants86335403ha_nts
harts88441593ha_rts
hashes125024803hashes
hatches153420273hatches
hatchets163310383hatchets
hats76858253ha__ts
haunts95614393haunts
hights133716893hights
ichs96214713_ich_s
inches114419673inches
itches114916213itches
jabots1538883jabots
jacals1539873jacals
jackets205011373jackets
jacks185219833jac_ks
jaunts137511883jaunts
kaphs144911503kaph_s
karats106420493karats
karsts106012943karsts
karts97630113ka_rts
kashas133311903kashas
kats85944333ka__ts
kwachas1943063kwachas
kyacks14416063kyac_ks
kyats125012443kya__ts
lacers85225253lacers
laces76141763lac_es
lacks116129203lac_ks
lacs66942483lac__s
laichs115110893laich_s
lakhs125210343lakh_s
lancets93411163lancets
larches124416443larches
lashes94831003lashes
lasts57731263la_sts
latches123320123latches
latchets133410013latchets
lathes95127493lathes
lathis95516173lathis
laths86022403lath_s
lats45962703la__ts
leaches123319343leaches
leches115421313leches
liches114724293liches
lichis115212593lichis
licht104723493licht_
lights104519913lights
loaches123613983loaches
lochs106715513loch_s
lyches144213613lyches
lynches15378873lynches
macaws1337023macaws
macers105321273macers
maces97139963mac_es
mach116134473mach__
mache125925303mach_e
machete14310883machete
machetes1539633machetes
macho126120153mach_o
macks135127603mac_ks
macles107023223macles
macons104017243macons
macros104017013macros
macs86742503mac__s
magots9312363magots
maists85817573maists
malts76331753ma_lts
manats84623463manats
manches143818623manches
manchets15269573manchets
marches143921173marches
marts77442233ma_rts
mascots113910343mascots
mashes115030003mashes
masts77035763ma_sts
matches143219783matches
maths105624023math_s
mats65460283ma__ts
matts76829183ma_tts
mauts75927193ma_uts
miches134320733miches
mights123516253mights
mochas13310653mochas
muches134718993muches
nacho105414383nach_o
nacres85614453nacres
naughts11447513naughts
niches114419143niches
nights104117723nights
oasts56529183oa_sts
oaths86117313oath_s
oats46554213oa__ts
oraches124216473oraches
orchis11710773orchis
ouches114322183ouches
oughts104710183oughts
pacas96029403pac_as
pacers105124543pacers
paces96741113pac_es
pacha126518063pach_a
pachisi14329523pachisi
packets155114773packets
packs135528933pac_ks
pacs85842183pac__s
pact86648723pac_t_
paints85921833paints
palets85122313palets
pants76536923pa_nts
parches143720003parches
parts77743373pa_rts
pashas115117063pashas
pashes115828393pashes
pasts75936503pa_sts
patches143320383patches
pathos115516693pathos
paths105521383path_s
pats66460853pa__ts
peaches144120053peaches
pechs125516203pech_s
picots104616443picots
placets113911223placets
poaches144416943poaches
qanats154112813qanats
qats135331343qa__ts
rabats83116223rabats
racers84725433racers
races74943243rac_es
rachet115028973rachet
rachitis1348353rachitis
racist82822793racist
racists92613323racists
rackets134916873rackets
racks115028853rac_ks
racons84319343racons
rafts87820633ra_fts
ramets83517393ramets
ranches123620113ranches
ranchos123911393ranchos
rants55935343ra_nts
raphes115117453raphes
raphis114014323raphis
rashes95330153rashes
ratches123620463ratches
ratchets133110263ratchets
rats46260373ra__ts
reaches123423203reaches
reacts83616603reac_ts
recits83621353recits
recuts83817373recuts
rhachis1555693rhachis
riches115022083riches
rights104019333rights
roaches123616213roaches
rochets124213473rochets
ruches114819583ruches
sabots8314693sabots
sacbuts1166473sacbuts
sachem134012223sachem
sachems14348903sachems
sachet114725773sachet
sacks114228873sac_ks
sacs65739073sac__s
sadhes104715373sadhes
sadhus10298463sadhus
saints65122423saints
salts55431883sa_lts
sashes94728483sashes
sauchs115112233sauch_s
saults65816173saults
scants85219723scants
scarts85321493scarts
scats75930603_scats
scatts85914663scatts
scots74025903_scots
scuts74522523_scuts
sects75622893sec_ts
sights103818013sights
synchs14408453synch_s
taces76237803tac_es
tacet75840023tacet_
tach96132753tach__
tache106222373tach_e
tachism1478873tachism
tachist12613293tachist
tachists1348183tachists
tacit76333673tacit_
tackets134914363tackets
tacks115430133tac_ks
tacos77023553tac_os
tact67349033tac_t_
tahrs85412333ta_hrs
taints64520533taints
tarots66422993tarots
tarts57242023ta_rts
tats46858133ta__ts
taunts65715663taunts
tauts56125513ta_uts
teaches122718353teaches
techs106915833tech_s
tights104015853tights
tracts85019073trac_ts
vacate11314553vacate
vacates12312833vacates
vacs96226203vac__s
valets93715623valets
vasts86423773va_sts
vats76841743va__ts
vaults94511673vaults
vaunts95212623vaunts
wackes154717713wackes
wackos155210993wackos
wacks146626283wac_ks
wafts116920553wa_fts
waists97415453waists
waits88333523wa_its
wants87932213wa_nts
warts814840403wa_rts
washes124425493washes
wasts87433673wa_sts
watches153017373watches
wats77555883wa__ts
watts86923093wa_tts
waucht14399413waucht_
waughts14355963waughts
wecht13415443wecht_
wiches144418753wiches
wights133315783wights
wyches17387913wyches
yachting1734933yachting
yachtings1842663yachtings
yachtman1842653yachtman
yachtmen1842433yachtmen
yachtsman1951813yachtsman
yachtsmen1951673yachtsmen
yack135425973yac__k
yacked164516793yacked
yaffs145311123ya_ffs
yagers105114533yagers
yagis95416573ya_gis
yags86632293ya__gs
yah99046353ya_h__
yahoo112911543ya_hoo
yahoos12209243yahoos
yairds10448023yairds
yaks116025203ya__ks
yamens114010823yamens
yams95330733ya__ms
yamuns11336513yamuns
yangs95618693ya_ngs
yanks125316573ya_nks
yapoks15346783yapoks
yapons114411773yapons
yaps95933523ya__ps
yards95324613ya_rds
yarest95018913yarest
yarns85621793ya_rns
yauds95013223ya_uds
yaups105910743ya_ups
yawls114613603ya_wls
yawns114213273ya_wns
yawps13628793ya_wps
yaws105531213ya__ws
yays105728913ya__ys
yeahs115214553yeah_s
yeasts96413053yeasts
yecchs16414953yecchs
yech127220533yech__
yechy16519083yech_y
yetts86715133y_etts
yirths12639533yirths
yocks144418373yoc_ks
yodhs12669013yodh_s
yoghs125410593yogh_s
youths124510043youths
yucas106013913yuc_as
yuccas13426553yuccas
yuch125818533yuch__
yucks144717193yuc_ks
yurts87216533y_urts

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 Filter1786911127160.220812231.8
2DLD Change Limit1127164697.18615685.5
3Display Results4694690.2361987.3
 (SQL Overall)1786914697.64223382.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.