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

231 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
stitcher1316839(None) 
snitcher13157371snitcher
stitched14148201stitched
stitchers14147011stitchers
stitchery17174071stitchery
stitches131410591stitches
switcher16177681switcher
ditcher134012002_ditcher
hitcher153712002_hitcher
pitcher143813712_pitcher
scutcher15176962scutcher
sketcher1735432sketcher
slither104112982slit_her
snatcher13167762snatcher
snitched14166862snitched
snitchers14166042snitchers
snitches13148982snitches
stancher13198812stancher
sticker133515882sti_cker
stitch11419102stitch__
stretcher1446292stretcher
switched17157132switched
switchers17146632switchers
switches16159132switches
swither133710992swit_her
tither94920282_tit_her
twitcher16135342twitcher
aitches123014363_aitches
attacher13125713attacher
batcher144414853_batcher
bewitcher1943003bewitcher
bitched153212923_bitched
bitchen14349733_bitchen
bitchery18236563_bitchery
bitches144117063_bitches
bitchier15307733_bitchier
blither124812173blit_her
botcher143613223_botcher
britches15278683britches
butcher143411163_butcher
catcher143115823_catcher
cither114616683_cit_her
clincher15347663clincher
ditched143711903_ditched
ditchers143610363_ditchers
ditches133215713_ditches
dither104417683_dit_her
dowitcher1842593dowitcher
either94517423_eit_her
etcher113912943__etcher
fetcher153510393_fetcher
filcher15377793_filcher
fitchee152710783_fitchee
fitches153516193_fitches
fitchet153113563_fitchet
fitchew18276803_fitchew
fletcher16306663fletcher
flincher16256583flincher
flitched17256293flitched
flitches16388463flitches
glitches14296653glitches
glitchier1542793glitchier
hatcher153314723_hatcher
hemstitcher2151793hemstitcher
hitched163312253_hitched
hitchers16379993_hitchers
hitches153616273_hitches
hither124417253_hit_her
incher114114033__incher
itched123812023__itched
itches114916213__itches
itchier12247673__itchier
ither84617603__it_her
kitchen16287683_kitchen
kvetcher2052813kvetcher
lither94520953_lit_her
matcher143214283_matcher
mither114218563_mit_her
neither1037573neit_her
notcher123610933_notcher
patcher143515143_patcher
pincher143812713_pincher
pitched153512923_pitched
pitchers153211483_pitchers
pitches143617753_pitches
pitchier15368273_pitchier
quitches2236193quitches
restitched1644133restitched
restitches1545063restitches
richer114015043_ri_cher
saithe94713913sait_he_
satchel123310303s_atchel
scorcher15196783scorcher
scotched16187933scotched
scotches15179473scotches
scratcher1635443scratcher
scutched16186893scutched
scutchers16175643scutchers
scutches15168883scutches
searcher13209103searcher
seiche11811833sei_che_
seiches12513813sei_ches
shicker163914823shi_cker
shittier1137313shittier
sicker124023903s_i_cker
sigher103813703s_i_gher
sitter63323383s_it_ter
sketched1835393sketched
sketchers1834513sketchers
sketches1746823sketches
sketchier1853413sketchier
skitter113810403skit_ter
slatches131511523slatches
slather103816073slat_her
slicer84117603sli_c_er
slicker133314533sli_cker
slithers114212953slit_hers
slithery14356703slit_hery
slitter73615873slit_ter
slittier837003slittier
sloucher13206813sloucher
smirched1634673smirched
smirches1535993smirches
smiter83616413smit__er
smithers13369793smit_hers
smithery16325703smit_hery
smoocher15205503smoocher
smother123510213smot_her
smutched16165923smutched
smutches15177273smutches
smutchier1643503smutchier
snatched14157633snatched
snatchers14146313snatchers
snatches131410713snatches
snatchier1455353snatchier
snicker133012673sni_cker
snitch11357943snitch__
soother104215043soot_her
souther104116303sout_her
spicer104719313spi_c_er
spicier115112463spi_cier
spitter94015183spit_ter
stacker134416263st_acker
staithe1037723stait_he_
staithes1138953stait_hes
stanched14208903stanched
stanchers14206813stanchers
stanches132312793stanches
starched14199313starched
starches131912913starches
starchier1436643starchier
stater64427563stat__er
stauncher1443513stauncher
stenches132110293stenches
stenchier1445333stenchier
stich104117923sti_ch__
stichic1446243sti_chic
stichs114511653sti_ch_s
sticked144114633sti_cked
stickers142913033sti_ckers
stickier14229763stickier
stickler14259573stickler
stiffer13319393sti_ffer
stifler102911473sti_fler
stiller73414293sti_ller
stillier868823stillier
stinger84314683sti_nger
stingier9279123stingier
stinker113313313sti_nker
stinkier12278543stinkier
stinter73614513sti_nter
stippler1235543stippler
stirrer7338233sti_rrer
stitcheries1653073stitcheries
stitching1547103stitching
stitchwort1852543stitchwort
stithied1235303stithied
stithies1139233stithies
stithy12398213stit_h_y
stiver93915733sti__ver
stocker133713083st_ocker
stomacher1694273stomacher
stretched1546213stretched
stretchers1545173stretchers
stretches1438293stretches
stretchier1544483stretchier
stricter1039423stricter
stuccoer1252803stuccoer
stutter72911463stut_ter
suiter64121813suit__er
swatches16169963swatches
swather134213603swat_her
swisher13369523swi_sher
switch14458913switch__
switcheroo1852063switcheroo
switchmen1962423switchmen
swithe124010683swit_he_
swithers144310533swit_hers
teacher123714833_teacher
tetched133010773_tetched
tetchier1336453_tetchier
tether93716103_tet_her
thatcher1635663thatcher
thither13328103thit_her
ticker124321503_ti_cker
titer55430613_tit__er
titfer9409523_tit_fer
tithe85319703_tit_he_
tithed104115593_tit_hed
tithers104216733_tit_hers
tithes94720213_tit_hes
titter63421163_tit_ter
tocher114014913_t_ocher
tother94117143_tot_her
toucher124814353_toucher
twitched17155033twitched
twitchers17134533twitchers
twitches16156373twitches
twitchier1753233twitchier
unstitched1643513unstitched
unstitches1543563unstitches
watcher153113403_watcher
whither163510253whit_her
wincher153410653_wincher
witched163012193_witched
witchery19236093_witchery
witches152715793_witches
witchier16307883_witchier
wither124321353_wit_her
writher134010853writ_her
zither183813083_zit_her

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622317.00020880.3
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.51623774.7
 
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.