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

300 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
snitch1135794(None) 
snatch114310601snatch
stitch11419101stitch
switch14458911switch
aitch105216162_aitch
bitch125017762_bitch
ditch115015092_ditch
fitch134816872_fitch
flitch14928172flitch
glitch12286352glitch
hitch134515472_hitch
itch95619172__itch
natch105018222_natch
notch105613322_notch
pitch125018412_pitch
quitch2036412quitch
saith85826552sait_h
scotch13207522scotch
scutch13247082scutch
sith75435152s_it_h
sketch1535362sketch
slatch114510532slatch
smirch1356462smirch
smith107818052smit_h
smutch13205842smutch
snatchy15355292snatchy
snath86419802snat_h
snick114416012sni_ck
snit46342472snit__
snitched14166862snitched
snitcher13157372snitcher
snitches13148982snitches
snits54124832snit_s
stich104117922sti_ch
swatch14549282swatch
swith115917402swit_h
twitch14406162twitch
unhitch1543052unhitch
witch134517562_witch
anarch11310393anarch
antic75728863antic_
antick124814583antick
antics84621453antics
baith108023133bait_h
batch124620103_batch
bewitch1743323bewitch
birch124914023_birch
bitchy16479203_bitchy
blotch13197143blotch
botch126717453_botch
brith104924373brit_h
butch125416543_butch
catch125120373_catch
chinch163911233chinch
cinch124516243_cinch
clinch133910353clinch
clutch13367753clutch
cratch134110793cratch
crotch133410083crotch
crutch13408243crutch
cultch13385953cultch
cutch125116193_cutch
dutch114713823_dutch
enrich1138943enrich
entice81316863entice
etch95419143__etch
faith115620853fait_h
fetch134913473_fetch
fetich1479693fetich
filch134813323_filch
finch135416973_finch
fitchy17437623_fitchy
fletch14388193fletch
flinch144010103flinch
frith115922033frit_h
glitchy16283083glitchy
grinch1238483grinch
grith95520373grit_h
grutch12285563grutch
hatch135719593_hatch
hootch14386413hootch
hotch136214733_hotch
hutch135414093_hutch
ich86227743__i_ch
inarch1139173inarch
inch95420823__inch
itchy13449013__itchy
ketch144912023_ketch
kith115826363_kit_h
kitsch1533353_kitsch
klatch15445933klatch
knish1238603kni_sh
knit85728143knit__
knits93914743knit_s
kvetch1832993kvetch
laich105920713lai_ch
laith85722103lait_h
latch104620463_latch
letch105215803_letch
lich96230843_li_ch
litchi1137893_litchi
match125621103_match
milch124413373_milch
mutch125016173_mutch
nautch1144813nautch
nice65534713_ni_ce
niche105016793_ni_che
nick106627603_ni_ck
niece74814503_niece
nigh85220663_ni_gh
ninth8314583_ninth
nit37065943_nit__
nitchie1247233_nitchie
nite45943583_nit_e
niter55028973_niter
nites55736343_nites
nitid61817833_nitid
niton55418283_niton
nitre57519683_nitre
nitro54914353_nitro
nits45741643_nit_s
nitty85418313_nitty
nth66320593_n_t_h
ontic74418573ontic_
painch133511323painch
patch125221223_patch
pinch125619303_pinch
pitchy16479673_pitchy
pith95432693_pit_h
ratch104221363_ratch
restitch1344693restitch
retch104818303_retch
rich97025543_ri_ch
rotch105815933_rotch
saice75424053sai_ce
saithe94713913saithe
samech13277033samech
sanity9316203sanit_y
sauch104918773s_auch
scooch13228123scooch
scootch1434463scootch
scorch13198093scorch
scratch1446013scratch
sculch13226213sculch
scultch1483543scultch
search113312423search
seiche11811833sei_che
seitan62613233seitan
seniti64317223senit_i
sheuch14267043sheuch
shibah14387473shibah
shit76745943shit__
shits84731173shit_s
shittah1385153shittah
shitty124110063shitty
shivah15488543shivah
shtick15308023shtick
sic55847873s_i_c_
sice65545593s_i_ce
sick106435573s_i_ck
sics65234093s_i_cs
sidh86222993s_i_dh
sigh85625893s_i_gh
since75024173s_ince
sinh76238043s_i_nh
sinter63625923sinter
sit35877753s_it__
sitar54820543s_itar
sitcom1036903s_itcom
site47052413s_it_e
sited65130743s_ited
sites56045433s_ites
sits45050203s_it_s
situp74414063s_itup
situs55019233s_itus
sixth155512233s_ixth
sketchy1943053sketchy
skit85437533skit__
skite95120053skit_e
skited114313483skited
skites104418043skites
skits94721863skit_s
slice74925823sli_ce
slick115520523sli_ck
slit46250103slit__
slits56128853slit_s
slitty9329163slitty
sloth85019453slot_h
slouch11438523slouch
smit65138413smit__
smite75224873smit_e
smiter83616413smiter
smites83921923smites
smiths114711023smiths
smithy14508273smithy
smooch13266803smooch
smutchy17193153smutchy
snack114718063sn_ack
snash84815673sn_ash
snatched14157633snatched
snatcher13167763snatcher
snatches131410713snatches
snathe94415113snathe
snaths95112913snaths
sneck114713663sn_eck
sneesh945893sneesh
snib66522983sni__b
snibs75613763sni_bs
snicks124312473snicks
snide64318723sni_de
snider74413913snider
sniff113915863sni_ff
sniffs12378843sniffs
sniffy15337193sniffy
snifter10349623snifter
snip66424653sni__p
snipe75320573sni_pe
sniped94913483sniped
sniper84413643sniper
snipes83917393snipes
snippy1374843snippy
snips75818013sni_ps
snitchers14166043snitchers
snitching1535913snitching
snivel9368853snivel
snot44745453snot__
snots55225123snot_s
snotty9489203snotty
snuck114411913sn_uck
sonic75225293soni_c_
sonics84315633soni_cs
sooth85924063soot_h
soth75932523s_ot_h
south85223573sout_h
speech1347563speech
spic85227433spi_c_
spica94717943spi_ca
spice95528813spi_ce
spick134519073spi_ck
spics94123243spi_cs
spicy125417713spi_cy
spilth11469733spilth
spinach1435403spinach
spit65545083spit__
spital83813873spital
spite75430663spit_e
spited94820443spited
spites84127333spites
spits74429553spit_s
spitz166017973spit_z
splotch1442853splotch
squinch2134833squinch
stanch113812373stanch
starch113013203starch
stench114111163stench
stichs114511653sti_chs
stick115121563sti_ck
stitched14148203stitched
stitcher13168393stitcher
stitches131410593stitches
stithy12398213stithy
stretch1236413stretch
such96424813s__uch
suit45649873suit__
suite54829563suit_e
suited74019423suited
suiter64121813suiter
suites63727403suites
suitor63311053suitor
suits55028053suit_s
sumach135310113sumach
swath115920383swat_h
swish115114823swi_sh
switched17157133switched
switcher16177683switcher
switches16159133switches
swithe124010683swithe
synch135011793s_ynch
synth113711823synt_h
thatch1435613thatch
twitchy18393573twitchy
unit45140073unit__
unite54828383unit_e
united74421543united
uniter64619143uniter
unites65024853unites
units54923433unit_s
unity84918493unit_y
unlatch1245053unlatch
unstitch1343593unstitch
vetch134411843_vetch
watch135617063_watch
which163910083whi_ch
wich125724743_wi_ch
winch135016663_winch
witchy17468593_witchy
with105730473_wit_h
wretch14326533wretch
zenith1839073zenit_h
zilch19438123_zilch

Search took 6 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.376475242.0
2DLD Change Limit1127163004.79623502.1
3Display Results3003000.0933225.8
 (SQL Overall)1786913005.26533939.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.