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

488 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
aitches12301436(None) 
bitches144117061bitches
ditches133215711ditches
fitches153516191fitches
hitches153616271hitches
itches114916211_itches
pitches143617751pitches
witches152715791witches
aches106132292a__ches
aitch105216162aitch__
apaches143411842apaches
arches114822042a_rches
attaches13137722attaches
batches144019612batches
birches143412322birches
bitched153212922bitched
bitchen14349732bitchen
botches143716022botches
britches15278682britches
butches144315362butches
catches144320772catches
cinches144215772cinches
cutches143216462cutches
ditched143711902ditched
ditcher134012002ditcher
ditchers143610362ditchers
etches114217762_etches
fetches153413892fetches
fiches145219532fi_ches
filches153410722filches
finches153914192finches
fitchee152710782fitchee
fitchet153113562fitchet
fitchets16307412fitchets
fitchew18276802fitchew
fitchews19274772fitchews
flitches16388462flitches
glitches14296662glitches
hatches153420272hatches
hitched163312252hitched
hitcher153712002hitcher
hitchers16379992hitchers
hotches153814362hotches
hutches153613522hutches
inches114419672_inches
itched123812022_itched
ketches164012192ketches
kitchen16287682kitchen
kitchens17195782kitchens
kithes135016652kit_hes
kitsches1734072kitsches
latches123320132latches
letches124015482letches
liches114724292li_ches
litchis1238372litchis
matches143219782matches
miches134320732mi_ches
mutches143314282mutches
nautches1336082nautches
niches114419142ni_ches
nitchies1339072nitchies
notches123513652notches
painches1588912painches
patches143320382patches
pinches144117932pinches
pitched153512922pitched
pitcher143813712pitcher
pitchers153211482pitchers
quitches2236192quitches
ratches123620462ratches
retches123318512retches
riches115022082ri_ches
rotches123515702rotches
snitches13148982snitches
stitches131410592stitches
switches16159132switches
tithes94720212tit_hes
twitches16156372twitches
vetches153411262vetches
watches153017372watches
wiches144418752wi_ches
winches154714372winches
witched163012192witched
withes124620842wit_hes
zilches21326302zilches
abashes12510373abashes
aces67645093a__c_es
ache96829823a__che_
ached119227833a__ched
acmes96020653a__cmes
acnes75922623a__cnes
acres76327763a__cres
actives12311523actives
aether94213673aet_her
aethers103614943aet_hers
affiches1945233affiches
agitates9310883agitates
aides65336603ai__des
aircheck1942903aircheck
airchecks2042673airchecks
aircrew12113913aircrew
aircrews13122813aircrews
airshed11258533airshed
airsheds12274963airsheds
airthed11328303airthed
airths95414253airth_s
airtimes1037503airtimes
aisles64721143ai_sles
aitchbones1752953aitchbones
aits46355533ait___s
althea938213alt_hea
altheas1038233alt_heas
amices105018013amic_es
amities9317383amit_ies
amitoses1039053amitoses
anchos114214893a_nchos
antes56334323ant__es
anthem113410343ant_hem
anthems12309423ant_hems
anther93715063ant_her
anthers103715203ant_hers
antres65021003ant_res
apache134210783apache_
apices104916263apic_es
arched125717323a_rched
archer115016243a_rcher
archers124414573a_rchers
articles10310243articles
ashes86230613a__shes
ates45047923a_t__es
atones65225773a_tones
attache12106693attache_
attached14165703attached
attacher13125713attacher
attachers14134883attachers
attires72312953attires
attunes737823attunes
avouches1634823avouches
axites134913833axit__es
babiches1735253babiches
baches135426943_baches
batched154114243batched
batcher144414853batcher
batchers153613273batchers
bathes116524833bat_hes
beaches144120653beaches
beeches143413883beeches
belches143514343belches
benches143918603benches
bewitches1943823bewitches
bices95029963bi_c_es
birched15349913birched
birchen14347883birchen
bitch125017763bitch__
bitchery18236563bitchery
bitchier15307733bitchier
bitchiest1636083bitchiest
bitchy16479203bitch_y
bites75641173bit__es
blotches1537433blotches
boches134618523_boches
botched153611903botched
botcher143613223botcher
botchers153511543botchers
braches144621223braches
brioches15227253brioches
bunches144116033bunches
butcher143411163butcher
butchers153710183butchers
caches137926913_caches
caleches15269943caleches
caliches153812273caliches
capuches1735513capuches
caroches15710693caroches
carritches1743083carritches
catcher143115823catcher
catchers153114063catchers
chinches18369363chinches
cinched153910863cinched
circles1139903circles
ciscoes113610733ciscoes
cites74435593cit__es
cither114616683cit_her
cithers124315773cit_hers
cities84524853cit_ies
citoles9312553citoles
cliches144213743cliches
clinches153910363clinches
cloches144113713cloches
clutches15307923clutches
coaches144018693coaches
conches144019813conches
cooches143515833cooches
couches144020473couches
cratches153012543cratches
creches14313093creches
crotches153411303crotches
crutches15359593crutches
culches143710743culches
cultches15316533cultches
curches143512743curches
datchas1347423datchas
detaches1439653detaches
dices86434243di_c_es
dishes104622653di_shes
ditch115015093ditch__
dites66339153dit__es
dither104417683dit_her
dithers114016153dit_hers
ditties83116983ditties
ditzes163212423dit_zes
douches134315233douches
dunches133312583dunches
earaches13411313earaches
eches106322163__eches
either94517423eit_her
etched123613703_etched
etcher113912943_etcher
etchers123411293_etchers
faithed1437163fait_hed
faiths124610273fait_h_s
fetched163710473fetched
fetcher153510393fetcher
fetchers16328863fetchers
fetiches1636953fetiches
fiacres1237253fiacres
fices106031163fi_c_es
fiche134616743fi_che_
fichus14388113fi_chus
ficoes114613463fi_coes
filched16307423filched
filcher15377793filcher
filchers16286863filchers
fishes125221343fi_shes
fitch134816873fitch__
fitchy17437623fitch_y
fleches153411443fleches
fletches16308853fletches
flinches16358953flinches
flitched17256293flitched
ganaches1437433ganaches
girshes11248293girshes
gites65630183git__es
gotchas1334613gotchas
grinches1436953grinches
grutches14285853grutches
gulches13398113gulches
hatched163414463hatched
hatchel153510753hatchel
hatchels16368673hatchels
hatcher153314723hatcher
hatchers163113173hatchers
hatchet153317563hatchet
hatchets163310383hatchets
haunches1656963haunches
hitch134515473hitch__
hither124417253hit_her
hooches153812523hooches
hootches1656973hootches
hotched163610923hotched
hunches153913463hunches
hutched16359883hutched
ices66129643_i_c_es
ichs96214713_i_ch_s
inched124514483_inched
incher114114033_incher
inchers123912523_inchers
itch95619173_itch__
itchier12247673_itchier
itchiest1336523_itchiest
itchy13449013_itch_y
ither84617603_it_her
kenches163912273kenches
kimchee1845603kimchee
kimchees1942943kimchees
kimchis1843733kimchis
kirsches1743843kirsches
kites95432543kit__es
kithe125917453kit_he_
kithed144613013kit_hed
kiths125814973kit_h_s
kitties113213623kitties
kittles113012493kittles
klatches17157143klatches
kvetches2053583kvetches
kythes16499133kyt_hes
laches116528353_laches
laichs115110893lai_ch_s
laities7320343lait_ies
larches124416453larches
latched133914073latched
latchet123117913latchet
latchets133410013latchets
lathes95127503lat_hes
latices9313763latic_es
launches1387903launches
leaches123319343leaches
leches115421313_leches
leeches123911933leeches
letched133912053letched
lethes94818083let_hes
lichee114017973li_chee
lichees123512783li_chees
lichen114012743li_chen
lichens123510683li_chens
lichis115212593li_chis
lichts113712383li_chts
litchi1137893litch_i
lithe84922013lit_he_
lither94520953lit_her
lithest10513913lit_hest
lithos94212553lit_hos
litotes7311183litotes
litres65220393lit_res
littles73212783littles
loaches123613983loaches
lunches124115443lunches
lurches123311663lurches
lyches144213613_lyches
lynches15378873lynches
maches134827233_maches
manches143818623manches
marches143921173marches
mastiches1647333mastiches
matched153513963matched
matcher143214283matcher
matchers153012433matchers
merches144013763merches
miche126219243mi_che_
miched143913393mi_ched
minces104420803minc_es
miscues11312393miscues
mites75141803mit__es
mither114218563mit_her
mithers123516733mit_hers
mitises9315543mitises
mitoses9312183mitoses
mitres83922073mit_res
mooches143714453mooches
mouches143815963mouches
muches134718993_muches
mulches143210673mulches
munches144215793munches
naches114622413_naches
niche105016793ni_che_
niched125514063ni_ched
nieces84112713niec_es
nitchie1247233nitchie
nites55736343nit__es
nitres65519333nit_res
notched134210303notched
notcher123610933notcher
notchers13279423notchers
oraches124216473oraches
ouches114322183_ouches
panaches15310293panaches
panoches1548123panoches
parches143720003parches
parritches1743223parritches
pastiches1637453pastiches
patched153514623patched
patcher143515143patcher
patchers153413303patchers
paunches1568173paunches
peaches144120053peaches
perches143717953perches
pieces104217273piec_es
pinched153812453pinched
pincher143812713pincher
pinchers153510613pinchers
pishes114722103pi_shes
pistaches1646673pistaches
pitch125018413pitch__
pitchier15368273pitchier
pitchiest1646703pitchiest
pitchmen1744333pitchmen
pitchy16479673pitch_y
pithed124615613pit_hed
piths105817543pit_h_s
pities83828083pit_ies
poaches144416943poaches
pooches143214163pooches
porches143815673porches
potiches1539203potiches
pouches144116743pouches
psyches1755803psyches
punches144816133punches
putsches1535313putsches
quaiches2235343quai_ches
quiches2139333quiches
ranches123620113ranches
ratchet124218333ratchet
ratchets133110263ratchets
raunches1368053raunches
reaches123423203reaches
retched133814273retched
rices75536153ri_c_es
richen113812513ri_chen
richens12349733ri_chens
richer114015043ri_cher
richest122813683ri_chest
rites54442553rit__es
ritzes154812943rit_zes
roaches123616213roaches
rotche114311983rotche_
rouches124217893rouches
ruches114819583_ruches
saices84221803sai_c_es
saithe94713913sait_he_
satchel123310303satchel
satchels13328163satchels
scotches15179473scotches
scutches15168883scutches
seiches12513813seiches
sices75637273si_c_es
sitcoms1145533sitcoms
sites56045433sit__es
sithens1039383sit_hens
situses72710493situses
sketches1746823sketches
slatches131511533slatches
smirches1535993smirches
smutches15177273smutches
snatches131410713snatches
snitched14166863snitched
snitcher13157373snitcher
snitchers14166043snitchers
staithes1138953stait_hes
stichs114511653stich_s
stitched14148203stitched
stitcher13168393stitcher
stitchers14147013stitchers
swatches16169963swatches
switched17157133switched
switcher16177683switcher
switchers17146633switchers
taches114224173_taches
teaches122718353teaches
tenches123515523tenches
tetched133010773tetched
thatches1637513thatches
tithe85319703tit_he_
tithed104115593tit_hed
tither94920283tit_her
tithers104216733tit_hers
titles63719923tit_les
titres64718933tit_res
titties73617363titties
tittles73413253tittles
torches123715443torches
touches125118343touches
troches123715343troches
tusches1237903tusches
twitched17155033twitched
twitcher16135343twitcher
twitchers17134533twitchers
tythes12419703tyt_hes
unhitches1743073unhitches
vices105725533vi_c_es
vichies15310623vi_chies
vittles103211113vittles
vouches153914113vouches
watched163012823watched
watcher153113403watcher
watchers163511793watchers
welches153710313welches
wenches152914133wenches
winces114819113winc_es
winched163110593winched
wincher153410653wincher
winchers16319223winchers
wishes124920953wi_shes
witch134517563witch__
witchery19236093witchery
witchier16307883witchier
witchiest1736313witchiest
witchy17468593witch_y
wites85536963wit__es
withe115220233wit_he_
withed134416233wit_hed
wither124321353wit_her
withers134417753wit_hers
withies133913543withies
wretches16257283wretches
writhes134811703writ_hes
wyches17387913_wyches
zither183813083zit_her
zithers193911973zit_hers

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.483369960.7
2DLD Change Limit1340274886.42320866.7
3Display Results4884880.1732820.8
 (SQL Overall)1786914887.07925242.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.