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

266 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
smirch135646(None) 
besmirch1742132besmirch
birch124914022_birch
march125622892_march
merch125417962_merch
milch124413372_milch
mirth106418892_mirth
scorch13198092scorch
search113312422search
smirched1634672smirched
smirches1535992smirches
smirk116612752smir_k
smirks124910122smirks
smirky15406942smirky
smith107818052smi_th
smooch13266802smooch
smutch13205842smutch
snitch11357942snitch
starch113013202starch
stich104117922sti_ch
stitch11419102stitch
switch14458912switch
airth85621023_airth
aitch105216163_aitch
amerce10310513amerce
amice96122873ami_ce
amici94217393ami_ci
amir65129753amir__
amirs75924923amir_s
anarch11310393anarch
arch98628443__arch
birth105619873_birth
bitch125017763_bitch
chinch163911233chinch
church1636483church
cinch124516243_cinch
circa9311403_circa
clinch133910353clinch
curch124415413_curch
ditch115015093_ditch
emic86422753emi_c_
emir65918703emir__
emirs76116163emir_s
enrich1138943enrich
eparch13258423eparch
exarch18196173exarch
filch134813323_filch
finch135416973_finch
firth115819533_firth
fitch134816873_fitch
flinch144010103flinch
flitch14928173flitch
girsh95310023_girsh
girth95618843_girth
glitch12286353glitch
grinch1238473grinch
hitch134515473_hitch
ich86227743__i_ch
inarch1139173inarch
inch95420823__inch
itch95619173__itch
kirsch1532713_kirsch
laich105920713lai_ch
larch105919793_larch
lich96230843_li_ch
lurch104814633_lurch
mach116134483_m_ach
marc87034633_marc_
marcs95726623_marcs
marsh105320853_marsh
match125621103_match
merc87225623_merc_
mercs96020453_mercs
mercy125916183_mercy
mic77647643_mi_c_
mica86428253_mi_ca
mice87442233_mi_ce
miche126219243_mi_che
mick126333433_mi_ck
micra96214973_micra
micro94715993_micro
mics87435153_mi_cs
mince95325233_mince
mincy125817413_mincy
mir57046773_mir__
mire66748233_mir_e
mired85729223_mired
mires75640883_mires
mirex146816623_mirex
miri66730373_mir_i
mirin75023153_mirin
mirk106729503_mir_k
mirks115122143_mirks
mirky146315523_mirky
mirs66940573_mir_s
mirths114912993_mirths
miry96326753_mir_y
mirza16410443_mirza
mooch125313613_mooch
morph121712513_morph
mouch124715803_mouch
much115224033_m_uch
mulch124012973_mulch
munch124917103_munch
mutch125016173_mutch
myrrh1337093_myrrh
nomarch1445353nomarch
omniarch1562723omniarch
osmic939913osmi_c_
osmics1036463osmi_cs
ostrich1238663ostrich
painch133511323painch
parch125123003_parch
perch124518833_perch
pinch125619303_pinch
pitch125018413_pitch
porch125918623_porch
quitch2036413quitch
rich97025543_ri_ch
saice75424053sai_ce
saith85826553sai_th
samech13277033samech
sauch104918773s_auch
scarce104013633scarce
scarph13429603scarph
scirrhi1242293scirrhi
scooch13228123scooch
scotch13207523scotch
sculch13226213sculch
scutch13247083scutch
seiche11811833sei_che
semiraw1246053semiraw
sheuch14267043sheuch
shibah14387473shibah
shire84727133shir_e
shires95225573shires
shirk124817843shir_k
shirks134814123shirks
shirr84716923shir_r
shirrs94413173shirrs
shirt84533903shir_t
shirts94918343shirts
shirty124312563shirty
shivah15488543shivah
sic55847873s_i_c_
sice65545593s_i_ce
sick106435573s_i_ck
sics65234093s_i_cs
sidh86222993s_i_dh
sigh85625893s_i_gh
since75024173s_ince
sinh76238043s_i_nh
sir35746673s_ir__
sire46150413s_ir_e
sired66134283s_ired
siree55238813s_iree
siren54525823s_iren
sires55945373s_ires
sirra54416323s_irra
sirrah9379753sirrah
sirs44338333s_ir_s
sirup74014913s_irup
sith75435153s_i_th
sixth155512233s_ixth
sketch1535363sketch
skirl96012913skir_l
skirls10449823skirls
skirr94810543skir_r
skirrs10448193skirrs
skirt95624663skir_t
skirts104111503skirts
slatch114510533slatch
slice74925823sli_ce
slick115520523sli_ck
slouch11438523slouch
smack134615453sm_ack
smarm95517603smar_m
smarms105712533smarms
smarmy13629353smarmy
smart75834093smar_t
smarts86218003smarts
smarty115013793smarty
smash104814433sm_ash
smerk115412723smer_k
smerks12449713smerks
smidge10378483smidge
smilax1535393smilax
smile74823923smi_le
smiled93716433smiled
smiler83916683smiler
smiles84522293smiles
smiley114012303smiley
smirching1744393smirching
smirked14307233smirked
smirker13327423smirker
smit65138413smi__t
smite75224873smi_te
smiter83616413smiter
smites83921923smites
smiths114711023smiths
smithy14508273smithy
smock135311673sm_ock
smoochy17223863smoochy
smoosh11236733smoosh
smooth11259203smooth
smush104410583sm_ush
smutchy17193153smutchy
snatch114310603snatch
snick114416013sni_ck
soiree62919483soiree
source8410673source
speech1347563speech
spic85227433spi_c_
spica94717943spi_ca
spice95528813spi_ce
spick134519073spi_ck
spics94123243spi_cs
spicy125417713spi_cy
spilth11469733spilth
spinach1435403spinach
spiral83715343spiral
spire75828693spir_e
spirea84015633spirea
spired94921863spired
spirem104214163spirem
spires84628113spires
spirit83519923spirit
spirt75032953spir_t
spirts85317133spirts
spiry105017353spir_y
squinch2134833squinch
stanch113812373stanch
starchy15286743starchy
stench114111163stench
stichs114511653sti_chs
stick115121563sti_ck
stir45723253stir__
stirk95717413stir_k
stirks104914243stirks
stirp76815503stir_p
stirps85011823stirps
stirs55921623stir_s
strick124813203strick
strict84821043strict
such96424813s__uch
sumach135310113sumach
surah86823253s_urah
swarth126012083swarth
swatch14549283swatch
swirl84514143swir_l
swirls94010133swirls
swirly12439253swirly
swish115114823swi_sh
swith115917403swi_th
synch135011793s_ynch
torch107420933_torch
twitch14406163twitch
umiac938963umiac_
umiack1435173umiack
umiacs1035663umiacs
which163910083whi_ch
wich125724743_wi_ch
winch135016663_winch
witch134517563_witch
yirth116513753_yirth
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.373479064.3
2DLD Change Limit1127162665.56320261.7
3Display Results2662660.0803325.0
 (SQL Overall)1786912666.01629702.6
 
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.