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

457 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
apaches14341183(None) 
apache134210771apache_
abashes12510372abashes
aches106132292__aches
aitches123014362aitches
apace94718382apac_e_
apathies1339002apathies
apices104916262apic_es
arches114822042a_rches
attaches13137722attaches
baches135426942_baches
beaches144120652beaches
braches144621222braches
caches137926912_caches
capuches1735512capuches
coaches144018692coaches
earaches13411302earaches
ganaches1437412ganaches
laches116528342_laches
leaches123319342leaches
loaches123613982loaches
maches134827232_maches
naches114622412_naches
oraches124216472oraches
paces96741112_pac_es
pachas135017142_pachas
panaches15310282panaches
papacies1439472papacies
parches143720002parches
pashes115828392_pashes
patches143320382patches
peaches144120052peaches
poaches144416942poaches
reaches123423202reaches
roaches123616212roaches
spaces104722632spac_es
spathes125116532spathes
taches114224172_taches
teaches122718352teaches
aahed917816443a_a_hed
aahs716428563a_a_h_s
abacas104414723abac_as
abacus10349763abac_us
abacuses1235763abacuses
abases85720773aba_ses
abashed1357663abashed
abates85825033aba_tes
abbacies1445483abbacies
acacias11510403acacias
aces67645093__ac_es
ache96829823__ache_
ached119227833__ached
acmes96020653__acmes
acnes75922623__acnes
acres76327763__acres
adages8412953ada_ges
affiches1945233affiches
agapes95212413aga_pes
agates76121343aga_tes
agaves104611513aga_ves
alates64833963ala_tes
alcades101011473alcades
alcahest1345353alcahest
alpacas1137073alpac_as
amahs107819063ama_h_s
amasses93912853amasses
amazes175613473ama_zes
amices105018013amic_es
anankes1138763anankes
anarchies1448183anarchies
anarchs1237093anarch_s
anchos114214893a_nchos
anlaces92313733anlac_es
apagoges12144693apagoges
apanages1137013apanages
apathy1437033apath_y
apatites10311293apatites
aperies9423203aperies
apes66047433ap___es
apexes1539133ap_exes
apheses12610703apheses
aphides134711203aphides
aphis105917133ap__his
apiaries10312723apiaries
apicals1159923apicals
aplites9314933aplites
apoapses1244713apoapses
apocopes1445993apocopes
apogees1037103apogees
apothem1444643apothem
apothems1544223apothems
apples104315763ap_ples
applies11311213applies
apposes11511473apposes
approaches1943323approaches
apres75426403ap__res
apses76823913ap__ses
apsides103911303apsides
arables91814973arables
arames84622573ara_mes
arcades101113193arcades
arched125717323a_rched
archer115016243a_rcher
archers124414573a_rchers
ashes86230613__ashes
ataxies142410013ataxies
attache12106693attache_
attached14165703attached
attacher13125713attacher
attachers14134883attachers
avouches1634823avouches
awakes135012473awa_kes
ayahs116813523aya_h_s
babiches1735253babiches
bached145519893_bached
backaches22146813backaches
bashes115631393_bashes
batches144019613batches
bathes116524833_bathes
beached154516553beached
beeches143413883beeches
belches143514343belches
benches143918603benches
birches143412323birches
bitches144117063bitches
blanches153311603blanches
bleaches153410673bleaches
boches134618523_boches
botches143716023botches
braces108427773brac_es
brachet144020313brachet
brachets154311983brachets
brachs134415753brach_s
branches153613803branches
brashes124518463brashes
breaches153714123breaches
broaches153211623broaches
bunches144116033bunches
butches144315363butches
cache125122483_cache_
cached145419203_cached
cachet134526413_cachet
cachets145014263_cachets
calashes13310533calashes
caleches15269933caleches
caliches153812263caliches
capouches1843633capouches
capuche1644433capuche_
capuched1843743capuched
caroaches1637793caroaches
caroches15710693caroches
cashes114729883_cashes
catches144320773catches
cinches144215773cinches
clachs133511323clach_s
clashes124017283clashes
cliches144213743cliches
cloches144113713cloches
coached153313843coached
coacher143714123coacher
coachers154312303coachers
conches144019813conches
cooches143515833cooches
couches144020473couches
cranches153114543cranches
crashes124618403crashes
cratches153012543cratches
creches14313093creches
culches143710743culches
curches143512743curches
cutches143216463cutches
daces85030683_dac_es
dachas124113253_dachas
dashes106124983_dashes
deashes113313903deashes
detaches1439653detaches
ditches133215713ditches
douches134315233douches
drachms1534253drachms
dunches133312583dunches
earache1239323earache_
eches106322163__eches
epacts105010393epac_ts
eparchies1646973eparchies
eparchs14196243eparch_s
epochs1335813epoch_s
etches114217763_etches
faces106439433_fac_es
facies113921593_facies
fashes124524023_fashes
fetches153413893fetches
fiacres1237253fiacres
fiches145219533_fiches
filches153410723filches
finches153914193finches
fitches153516193fitches
flashes133916103flashes
fleches153411443fleches
gamashes1456943gamashes
ganache1346203ganache_
gashes105725153_gashes
gazpachos2651343gazpachos
glaces94218023glac_es
gnashes11419573gnashes
gouaches1436193gouaches
graces94523493grac_es
gulches13398103gulches
halachas16317883halachas
hapaxes1936593hapa_xes
hashes125024803_hashes
hatches153420273hatches
haunches1656963haunches
headaches1845033headaches
hitches153616273hitches
hooches153812523hooches
hotches153814363hotches
huaraches1744993huaraches
hunches153913463hunches
hutches153613523hutches
impeaches1843873impeaches
inarches1358043inarches
inches114419673_inches
itches114916213_itches
kenches163912273kenches
ketches164012193ketches
klatches17157133klatches
kwachas1943063kwachas
laces76141763_lac_es
larches124416443larches
lashes94831003_lashes
latches123320123latches
lathes95127493_lathes
launches1387903launches
lavashes1445573lavashes
leached133715043leached
leacher124014843leacher
leachers133712813leachers
leashes103514403leashes
leches115421313_leches
leeches123911933leeches
letches124015483letches
liches114724293_liches
loathes103513243loathes
lunches124115443lunches
lurches123311663lurches
lyches144213613_lyches
lynches15378873lynches
maces97139963_mac_es
mache125925303_mache_
machos135217493_machos
machs125722563_mach_s
macles107023223_macles
manacles1239523manacles
manches143818623manches
marches143921173marches
mashes115030003_mashes
matches143219783matches
merches144013763merches
miches134320733_miches
mooches143714453mooches
mouches143815963mouches
muches134718993_muches
mulches143210673mulches
munches144215793munches
mutches143314283mutches
nachas114914193_nachas
nachos115014183_nachos
nacres85614453_nacres
nautches1336083nautches
niches114419143_niches
notches123513653notches
opahs105411983opa_h_s
opaques1833643opaques
orache114013593orache_
oracles93212423oracles
ouches114322183_ouches
pacas96029403_pac_as
pace86345773_pac_e_
paced106931683_pac_ed
pacer96131613_pac_er
pacers105124543_pacers
pacey126720283_pac_ey
pacha126518063_pach_a
pachisi14329523_pachisi
pacier105018683_pacier
paciest112917803_paciest
packed154822603_packed
packer144223403_packer
packers153818893_packers
packet144726503_packet
packets155114773_packets
packs135528933_pac_ks
pacs85842183_pac__s
pacts95125803_pac_ts
padles95221123_padles
padres95016983_padres
pages85235073_pa_ges
painches1588913painches
palaces114216453palac_es
pales75753803_pa_les
panache1458423panache_
panes76148693_pa_nes
pannes85522853_pannes
panoches1548123panoches
parched154013693parched
parchesi15358213parchesi
pares77164483_pa_res
parges94529543_parges
paries84742513_paries
parles86334403_parles
parses85534703_parses
pases75346503_pa_ses
pashas115117063_pashas
pashed125923143_pashed
passes86030473_passes
pastes85233913_pastes
patched153514623patched
patcher143515143patcher
patchers153413303patchers
pates76047893_pa_tes
pathos115516693_pathos
paths105521383_path_s
paunches1568173paunches
pauses84621473_pauses
paves104833923_pa_ves
paxes144928423_pa_xes
payees114812903_payees
peaces106324083peac_es
peached154315883peached
peacher144216073peacher
peachers153213843peachers
peched144915343_peched
pechs125516203_pech_s
perches143717953perches
pinches144117933pinches
pishes114722103_pishes
pitches143617753pitches
places104323703plac_es
planches153111863planches
plashes124417393plashes
pleaches153210433pleaches
poached154212403poached
poacher143912323poacher
poachers152910763poachers
pooches143214163pooches
porches143815673porches
pouches144116743pouches
preaches153214893preaches
psyches1755803psyches
puces94924633_puc_es
punches144816133punches
pushes114621663_pushes
quaiches2235343quaiches
quashes192110973quashes
quiches2139333quiches
races74943243_rac_es
rachet115028973_rachet
rachets124516833_rachets
rachis114017653_rachis
ranches123620113ranches
raphes115117453_raphes
rashes95330153_rashes
ratches123620463ratches
raunches1368053raunches
reached134619083reached
reacher123718293reacher
reachers133515723reachers
repatches1636713repatches
retches123318513retches
rhachis1555693rhachis
rhaphes1534703rhaphes
riches115022083_riches
roached133211833roached
rotches123515703rotches
rouches124217893rouches
ruches114819583_ruches
sachem134012223_sachem
sachems14348903_sachems
sachet114725773_sachet
sachets123914103_sachets
sadhes104715373_sadhes
sashes94728483_sashes
scathes124515713scathes
searches132112903searches
seiches12513813seiches
slashes103619103slashes
slatches131511523slatches
smashes123914613smashes
snashes105214753snashes
snatches131410713snatches
snathes104816493snathes
space95325673spac_e_
spaced114517253spac_ed
spacer104917793spac_er
spacers113813873spacers
spacey136212533spac_ey
spacier114011633spacier
spaciest122310893spaciest
spackles16319953spackles
spades94222583spa_des
spaes76029973spa__es
spahee11313443spa_hee
spahees1238263spahees
spahis11310383spa_his
spales84728103spa_les
spares84834553spa_res
sparges104016343sparges
spates85028173spa_tes
spathe115115693spathe_
spathed134013183spathed
spavies123012943spavies
spazzes1735263spazzes
species11314133species
speeches1537413speeches
spices104326033spic_es
spinaches1645273spinaches
splashes1337503splashes
stactes91914633stactes
stanches132312793stanches
starches131912913starches
stashes103916173stashes
swashes134714403swashes
swatches16169963swatches
swathes134115513swathes
taces76237803_tac_es
tache106222373_tache_
tachs105820933_tach_s
takahes1436173taka_hes
teacher123714833teacher
teachers133212393teachers
tenches123515523tenches
thatches1637513thatches
torches123715433torches
touches125118343touches
traces85329933trac_es
trachea12311673trachea
tracheas13410273tracheas
trachles13311753trachles
tranches132915513tranches
trashes104119263trashes
troches123715343troches
tusches1237903tusches
upases84112903upa_ses
upreaches1654633upreaches
vetches153411263vetches
vouches153914113vouches
wackes154717713_wackes
washes124425493_washes
watches153017373watches
welches153710313welches
wenches152914133wenches
wiches144418753_wiches
winches154714373winches
witches152715793witches
wyches17387913_wyches
yachts1437023_yachts
zilches21326303zilches

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 Filter1786911340270.436409841.7
2DLD Change Limit1340274577.03019065.0
3Display Results4574570.1732641.6
 (SQL Overall)1786914577.63923391.9
 
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.