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

225 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
twitch1440616(None) 
switch14458911switch
twitchy18393571twitchy
witch134517561_witch
aitch105216162_aitch
bewitch1743322bewitch
bitch125017762_bitch
ditch115015092_ditch
fitch134816872_fitch
flitch14928172flitch
glitch12286352glitch
hitch134515472_hitch
itch95619172__itch
pitch125018412_pitch
quitch2036412quitch
snitch11357942snitch
stitch11419102stitch
swatch14549282swatch
swith115917402swit_h
thatch1435602thatch
twice104711122twi_ce
twit76329062twit__
twitched17155032twitched
twitcher16135342twitcher
twitches16156372twitches
twits86015792twit_s
watch135617062_watch
wich125724742_wi_ch
winch135016662_winch
witchy17468592_witchy
with105730472_wit_h
baith108023133bait_h
batch124620103_batch
birch124914023_birch
bitchy16479203_bitchy
blotch13197143blotch
botch126717453_botch
brith104924373brit_h
butch125416543_butch
catch125120373_catch
chinch163911223chinch
cinch124516243_cinch
clinch133910353clinch
clutch13367753clutch
cratch134110793cratch
crotch133410083crotch
crutch13408243crutch
cultch13385953cultch
cutch125116193_cutch
dutch114713823_dutch
etch95419143__etch
faith115620853fait_h
fetch134913473_fetch
fetich1479693fetich
filch134813323_filch
finch135416973_finch
fitchy17437623_fitchy
fletch14388193fletch
flinch144010103flinch
frith115922033frit_h
glitchy16283083glitchy
grinch1238473grinch
grith95520373grit_h
grutch12285563grutch
hatch135719593_hatch
hootch14386403hootch
hotch136214723_hotch
hutch135414093_hutch
ich86227743__i_ch
inch95420823__inch
itchy13449013__itchy
ketch144912023_ketch
kith115826353_kit_h
kitsch1533353_kitsch
klatch15445933klatch
kvetch1832993kvetch
laich105920713lai_ch
laith85722103lait_h
latch104620463_latch
letch105215803_letch
lich96230843_li_ch
litchi1137893_litchi
match125621103_match
milch124413373_milch
mutch125016173_mutch
natch105018223_natch
nautch1144813nautch
notch105613323_notch
outbitch1543443outbitch
outpitch1543283outpitch
outwatch1643903outwatch
outwith13279133outwit_h
painch133511323painch
patch125221223_patch
pinch125619303_pinch
pitchy16479673_pitchy
pith95432693_pit_h
ratch104221363_ratch
retch104818303_retch
rich97025543_ri_ch
rotch105815933_rotch
saith85826553sait_h
scotch13207513scotch
scutch13247083scutch
sith75435153_sit_h
sketch1535353sketch
slatch114510533slatch
smirch1356463smirch
smith107818043smit_h
smutch13205843smutch
snatch114310603snatch
stich104117923sti_ch
stretch1236413stretch
swath115920383swat_h
swish115114823swi_sh
switched17157133switched
switcher16177683switcher
switches16159133switches
swithe124010683swithe
tach96132753t__ach
teach105221123t_each
tech95925443t__ech
teeth87315853teet_h
tench105620003t_ench
tenth85421833tent_h
tetchy1436003t_etchy
teth76327883t_et_h
teuch105214853t_euch
thatchy1833303thatchy
thick145613353thi_ck
thigh12410113thi_gh
tic56343463t_i_c_
tick106231223t_i_ck
tics65729633t_i_cs
tilth85515363t_ilth
tinct76126233t_inct
tit36771043t_it__
titan53318173t_itan
titer55430613t_iter
tithe85319703t_ithe
titi47130613t_it_i
titis56023813t_itis
title54721073t_itle
titre54619393t_itre
tits46145033t_it_s
titty85316653t_itty
toit46353063toit__
toited74016753toited
toits55327473toit_s
tooth88020183toot_h
torch107420933t_orch
touch106519393t_ouch
trench114211613trench
triac74116373triac_
triacs83913223triacs
trice75127493tri_ce
trick115420693tri_ck
triptych1842283triptych
tristich1348423tristich
trite54730033trit_e
triter65120593triter
triton63914893triton
troth85622203trot_h
truth85214153trut_h
twat75831513twat__
twats86616603twat_s
twibil1133563twibil
twier84713293twi_er
twiers95410163twiers
twig87615773twi__g
twiggy1432933twiggy
twigs96911173twi_gs
twilit949553twilit
twill85612723twi_ll
twills9489793twills
twin76023083twi__n
twine85822363twi_ne
twined104413123twined
twiner94012593twiner
twines94717273twines
twinge104210393twinge
twins85118983twi_ns
twiny116012813twi_ny
twirl85011943twi_rl
twirls9478123twirls
twirly12427083twirly
twirp10468943twi_rp
twirps11415013twirps
twist86820983twi_st
twisted11277433twisted
twister10308953twister
twists9549753twists
twisty12426863twisty
twitchers17134533twitchers
twitchier1753233twitchier
twitchily2052193twitchily
twitching1834243twitching
twitted11326633twitted
twitter10278093twitter
twixt155512483twi_xt
unhitch1543053unhitch
vetch134411843_vetch
welch134411493_welch
wench136214783_wench
which163910083_which
wicca1247253_wicca
wick135726303_wi_ck
width12310963_width
wilco1039443_wilco
wince105220883_wince
wish107228733_wi_sh
wit66563773_wit__
witan83816503_witan
witched163012193_witched
witches152715793_witches
wite75443273_wit_e
wited94727143_wited
wites85536963_wites
withe115220233_withe
withy144813763_withy
wits76044873_wit_s
witty114717013_witty
wretch14326533wretch
wych154011883_w_ych
zilch19438123_zilch

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162256.67316891.4
3Display Results2252250.0633571.4
 (SQL Overall)1786912256.87625987.6
 
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.