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

180 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
twitcher1613534(None) 
switcher16177681switcher
twitched17155031twitched
twitchers17134531twitchers
twitches16156371twitches
twitchier1753231twitchier
bewitcher1943002bewitcher
ditcher134012002_ditcher
dowitcher1842592dowitcher
hitcher153712002_hitcher
pitcher143813712_pitcher
snitcher13157372snitcher
stitcher13168392stitcher
switched17157132switched
switchers17146632switchers
switches16159132switches
swither133710992swit_her
thatcher1635662thatcher
thither13328102thit_her
tither94920282t_it_her
twitch14406162twitch__
twitchy18393572twitch_y
twitter10278092twit_ter
watcher153113402_watcher
wincher153410652_wincher
witched163012192_witched
witchery19236092_witchery
witches152715792_witches
witchier16307882_witchier
wither124321352_wit_her
aitches123014363_aitches
atwitter1143673atwit_ter
batcher144414853_batcher
bewitched2043233bewitched
bewitchers2042563bewitchers
bewitchery2351663bewitchery
bewitches1943823bewitches
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
dowitchers1942133dowitchers
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
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
richer114015043_ri_cher
scutcher15176963scutcher
sketcher1735433sketcher
slither104112983slit_her
snatcher13167763snatcher
snitched14166863snitched
snitchers14166043snitchers
snitches13148983snitches
stitched14148203stitched
stitchers14147013stitchers
stitchery17174073stitchery
stitches131410593stitches
stretcher1446293stretcher
swatches16169963swatches
swather134213603swat_her
swisher13369523swi_sher
switch14458913switch__
switcheroo1852063switcheroo
switchmen1962423switchmen
swithe124010683swit_he_
swithers144310533swit_hers
teacher123714833t_eacher
teether10349693teet_her
tetched133010773t_etched
tetchier1336453t_etchier
tether93716103t_et_her
thatched1735433thatched
thatchers1744583thatchers
thatches1637513thatches
thatchier1743983thatchier
thicker163611023thi_cker
ticker124321503t_i_cker
titer55430613t_it__er
titfer9409523t_it_fer
tithe85319703t_it_he_
tithed104115593t_it_hed
tithers104216733t_it_hers
tithes94720213t_it_hes
titter63421163t_it_ter
tocher114014913t__ocher
tother94117143t_ot_her
toucher124814353t_oucher
trencher13279313trencher
tricker134615523tri_cker
triter65120593trit__er
twice104711123twi_c_e_
twiddler13244873twiddler
twier84713293twi___er
twiggier1333073twiggier
twiner94012593twi__ner
twinier1037313twi_nier
twinkler1564073twinkler
twirler10285203twi_rler
twirlier1133513twirlier
twister10308953twi_ster
twistier1134813twistier
twitchiest1842963twitchiest
twitchily2052193twitchily
twitching1834243twitching
twitted11326633twit_ted
twitterer1243303twitterer
twitters11296773twit_ters
twittery14303893twit_tery
watched163012823_watched
watchers163511793_watchers
watches153017373_watches
welcher15319393_welcher
wencher153811133_wencher
wether123315393_wet_her
whither163510253whit_her
wiches144418753_wi_ches
wicker154518673_wi_cker
wincer115018193_winc_er
winched163110593_winched
winchers16319223_winchers
winches154714373_winches
wisher123617063_wi_sher
witch134517563_witch__
witchy17468593_witch_y
withe115220233_wit_he_
withed134416233_wit_hed
withers134417753_wit_hers
withes124620843_wit_hes
withier132910493_withier
wittier103910823_wittier
writher134010853writ_her
wuther124511613_wut_her
zither183813083_zit_her

Search took 7 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.420425454.8
2DLD Change Limit1461621806.40622816.4
3Display Results1801800.0802250.0
 (SQL Overall)1786911806.90625874.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.