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

409 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
hitcher15371200(None) 
ditcher134012001ditcher
hatcher153314721hatcher
hitched163312251hitched
hitchers16379991hitchers
hitches153616271hitches
hither124417251hit_her
pitcher143813711pitcher
aitches123014362aitches
batcher144414852batcher
bitched153212922bitched
bitchen14349732bitchen
bitchery18236562bitchery
bitches144117062bitches
bitchier15307732bitchier
botcher143613222botcher
butcher143411162butcher
catcher143115822catcher
cither114616682cit_her
ditched143711902ditched
ditchers143610362ditchers
ditches133215712ditches
dither104417682dit_her
either94517422eit_her
etcher113912942_etcher
fetcher153510392fetcher
filcher15377792filcher
fitchee152710782fitchee
fitches153516192fitches
fitchet153113562fitchet
fitchew18276802fitchew
hatched163414462hatched
hatchel153510752hatchel
hatchers163113172hatchers
hatchery19326382hatchery
hatches153420272hatches
hatchet153317562hatchet
higher134610892hi_gher
hitch134515472hitch__
hitter94419862hit_ter
hotched163610922hotched
hotches153814362hotches
hutched16359882hutched
hutches153613522hutches
incher114114032_incher
itched123812022_itched
itches114916212_itches
itchier12247672_itchier
ither84617602_it_her
kitchen16287682kitchen
lither94520952lit_her
matcher143214282matcher
mither114218562mit_her
notcher123610932notcher
patcher143515142patcher
pincher143812712pincher
pitched153512922pitched
pitchers153211482pitchers
pitches143617752pitches
pitchier15368272pitchier
richer114015042ri_cher
snitcher13157372snitcher
stitcher13168382stitcher
switcher16177682switcher
thatcher1635652thatcher
thither13328102thit_her
tither94920282tit_her
twitcher16135342twitcher
watcher153113402watcher
whither163510252whit_her
wincher153410652wincher
witched163012192witched
witchery19236092witchery
witches152715792witches
witchier16307882witchier
wither124321352wit_her
zither183813082zit_her
aether94213673aet_her
aitch105216163aitch__
anther93715063ant_her
archer115016243_archer
attacher13125713attacher
batched154114243batched
batchers153613273batchers
batches144019613batches
bather115322513bat_her
belcher143511493belcher
bencher144113483bencher
bewitcher1943003bewitcher
bicker144819173bi_cker
birched15349913birched
birchen14347883birchen
birches143412323birches
bitch125017763bitch__
bitchy16479203bitch_y
biter75030033bit__er
bitsier9379073bitsier
bitter84622673bit_ter
bittier94211663bittier
blither124812173blit_her
blucher143310223blucher
botched153611903botched
botchers153511543botchers
botchery18366763botchery
botches143716023botches
botchier15287143botchier
bother115218063bot_her
britches15278683britches
butchers153710183butchers
butchery18326253butchery
butches144315363butches
catchers153114053catchers
catches144320763catches
catchier15329863catchier
chicer134513603chi_c_er
chichier1836023chi_chier
chinches18369363chinches
chinchier1944633chinchier
chitchat1846053chitchat
chitter124112963chit_ter
cinched153910863cinched
cinches144215773cinches
cipher133710263ci_pher
circler1136423circler
citer74827323cit__er
cithern12489913cit_hern
cithers124315753cit_hers
clincher15347663clincher
coacher143714113coacher
coucher144515853coucher
cutchery18265173cutchery
cutches143216453cutches
detacher1437543detacher
dicer85426423di_c_er
dicier94416233di_cier
dicker134521403di_cker
dictier103411863dictier
diether1147443diether
ditch115015093ditch__
dithers114016153dit_hers
dithery14318943dit_hery
ditsier83010293ditsier
ditzier17307963ditzier
dowitcher1842593dowitcher
etched123613703_etched
etchers123411293_etchers
etches114217763_etches
ether84518773_et_her
father125116713fat_her
fetched163710473fetched
fetchers16328863fetchers
fetches153413893fetches
fiche134616743fi_che_
fiches145219533fi_ches
filched16307423filched
filchers16286863filchers
filches153410723filches
finches153914193finches
fisher124917143fi_sher
fitch134816873fitch__
fitchets16307413fitchets
fitchews19274773fitchews
fitchy17437623fitch_y
fitter94120033fit_ter
fletcher16306663fletcher
flincher16256583flincher
flitched17256293flitched
flitches16388463flitches
gather104115853gat_her
gaucher1337233gaucher
glitches14296653glitches
glitchier1542793glitchier
hacker154822693h_acker
harsher13310363harsher
hatch135719593hatch__
hatcheck2244013hatcheck
hatchels16368673hatchels
hatchets163310383hatchets
hater85034753hat__er
hatter94724873hat_ter
heather133914853heather
hickey185011993hi_ckey
hider95024083hi__der
higgler12369803higgler
hijacker2442463hijacker
hiker125119393hi__ker
hiller94421633hi_ller
hillier103413963hillier
hinder104120063hi_nder
hinger104723313hi_nger
hinkier143610793hinkier
hinter94021303hi_nter
hipper133818023hi_pper
hippier143212103hippier
hipster12288783hipster
hirer85423123hi__rer
hisser94713793hi_sser
hissier103410503hissier
hitchhiker2151263hitchhiker
hitching173310523hitching
hitherto1444353hit_herto
hitmen11239193hit_men
hitters104717583hit_ters
hocker155118563h_ocker
hooches153812523hooches
hootches1656973hootches
hotch136214723hotch__
hotter94720073hot_ter
hunched163710493hunched
hunches153913463hunches
hutch135414093hutch__
ichor1039473_i_chor
icier74313743_i_cier
icker114018443_i_cker
inched124514483_inched
inchers123912523_inchers
inches114419673_inches
itch95619173_itch__
itchy13449013_itch_y
jitter133314993jit_ter
ketches164012193ketches
kicker114116183ki_cker
kimchee1845603kimchee
kitchens17195783kitchens
kiter95523213kit__er
kithe125917453kit_he_
kithed144613013kit_hed
kithes135016653kit_hes
kitsches1734073kitsches
kittler11338163kittler
kvetcher2052813kvetcher
latched133914063latched
latches123320123latches
latchet123117903latchet
lather95124353lat_her
leacher124014843leacher
lecher113415853_lecher
letched133912053letched
letches124015483letches
lichee114017973li_chee
lichen114012743li_chen
liches114724293li_ches
licker125222043li_cker
litchi1137893litch_i
litchis1238373litchis
liter54736343lit__er
lithe84922013lit_he_
litter64324853lit_ter
littler7348553littler
luncher123111413luncher
lurcher12338133lurcher
lyncher15366553lyncher
marcher143912973marcher
matched153513963matched
matchers153012433matchers
matches143219783matches
miche126219243mi_che_
miched143913393mi_ched
miches134320733mi_ches
mincer104017363minc_er
mincier113512463mincier
miter75734793mit__er
miterer92511333miterer
mithers123516733mit_hers
mitier83620663mit_ier
moocher143610673moocher
mother113718643mot_her
muncher143610373muncher
mutches143314283mutches
neither1037573neit_her
nether94014163net_her
nicer74618293ni_c_er
niche105016793ni_che_
niched125514063ni_ched
niches114419143ni_ches
nicker123818703ni_cker
nigher103612753ni_gher
nitchie1247233nitchie
nitchies1339073nitchies
niter55028973nit__er
nittier73512243nittier
notched134210303notched
notchers13279423notchers
notches123513653notches
nother93815963not_her
ocher104516103__ocher
other84219103_ot_her
patched153514623patched
patchers153413303patchers
patches143320383patches
patchier15319663patchier
peacher144216073peacher
percher143313423percher
picker144422173pi_cker
piecer105213083piec_er
pincer104019173pinc_er
pinched153812453pinched
pinchers153510613pinchers
pinches144117933pinches
pinscher1544803pinscher
pisher114317753pi_sher
pitch125018413pitch__
pitchmen1744333pitchmen
pitchy16479673pitch_y
pithed124615613pit_hed
pithier123010293pithier
pitier84019823pit_ier
poacher143912323poacher
pother113818853pot_her
puncher143311673puncher
quitches2236193quitches
rancher123013633rancher
ratches123620463ratches
ratchet124218333ratchet
rather94319733rat_her
reacher123718293reacher
retched133814273retched
retches123318513retches
ricer74726613ri_c_er
richen113812513ri_chen
riches115022083ri_ches
ritter63822413rit_ter
ritzier16297203ritzier
rotche114311983rotche_
rotches123515703rotches
satchel123310303satchel
scutcher15176963scutcher
shicker163914823shi_cker
shittier1137303shittier
sicker124023903si_cker
sigher103813703si_gher
sitter63323383sit_ter
sketcher1735433sketcher
slither104112983slit_her
snatcher13167753snatcher
snitched14166863snitched
snitchers14166043snitchers
snitches13148983snitches
sticker133515883sticker
stitched14148203stitched
stitchers14146993stitchers
stitchery17174063stitchery
stitches131410593stitches
switched17157133switched
switchers17146633switchers
switches16159133switches
swither133710993swit_her
teacher123714833teacher
tetched133010773tetched
tetchier1336453tetchier
tether93716103tet_her
thatched1735433thatched
thatchers1744573thatchers
thatches1637513thatches
thatchier1743983thatchier
thicker163611023thi_cker
ticker124321503ti_cker
titer55430613tit__er
titfer9409523tit_fer
tithe85319703tit_he_
tithed104115593tit_hed
tithers104216733tit_hers
tithes94720213tit_hes
titter63421163tit_ter
tocher114014913_tocher
tother94117143tot_her
toucher124814353toucher
twitched17155033twitched
twitchers17134533twitchers
twitches16156373twitches
twitchier1753233twitchier
unhitched1843093unhitched
unhitches1743073unhitches
vetches153411263vetches
vitamer1235473vitamer
voucher154110263voucher
watched163012823watched
watchers163511793watchers
watches153017373watches
welcher15319393welcher
wencher153811133wencher
wether123315393wet_her
whether16346623whet_her
whicker19359773whi_cker
whitener1435733whitener
whiter124316393whit__er
whitier133311063whit_ier
whitter139110893whit_ter
whittler1495193whittler
wiches144418753wi_ches
wicker154518673wi_cker
wincer115018193winc_er
winched163110593winched
winchers16319223winchers
winches154714373winches
wisher123617063wi_sher
witch134517563witch__
witchy17468593witch_y
withe115220233wit_he_
withed134416233wit_hed
withers134417753wit_hers
withes124620843wit_hes
withier132910493withier
wittier103910823wittier
writher134010853writ_her
wuther124511613wut_her
zilches21326303zilches
zithern19447023zit_hern
zithers193911973zit_hers

Search took 9 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.1561145455.1
2DLD Change Limit1340274097.97016816.4
3Display Results4094090.1562621.8
 (SQL Overall)1786914098.28221575.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.