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

410 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
painch13351132(None) 
paunch13369851paunch
pinch125619301p_inch
aitch105216162_aitch
chinch163911222chinch
cinch124516242_cinch
clinch133910352clinch
finch135416972_finch
flinch144010102flinch
grinch1238472grinch
haunch14377342haunch
inch95420822__inch
laich105920712lai_ch
launch11368062launch
pain65647242pain__
painches1588912painches
pained95622852pained
pains75138282pain_s
paint75443692pain_t
paints85921832paints
painty114714752painty
panic93923902panic_
panics103815362panics
parch125123002pa_rch
patch125221222pa_tch
paunchy17324442paunchy
pitch125018412p_itch
planch133711442planch
plench134010812plench
plinth11310452plinth
prince104114762prince
punch125118422p_unch
ranch105019792ra_nch
raunch11358432raunch
winch135016662_winch
ain37579093_ain__
ains46158883_ain_s
airth85621023_airth
ancho104515303_a_ncho
ankh111114413_a_nkh
apiece10510083apiece
aping87327233apin_g
apish105116633api_sh
arch98628443_a_rch
bach116131393ba__ch
baith108023133bai_th
banco94019393ba_nco
banish111416043banish
batch124620103ba_tch
bench125619503_bench
birch124914023_birch
bitch125017763_bitch
blanch133410853blanch
blench133710453blench
branch134014773branch
brunch13329353brunch
bunch125118603_bunch
cain65643913cain__
cains75334303cain_s
cancha134411613ca_ncha
caroch13911763caroch
catch125120373ca_tch
chinchy20335513chinchy
clench133910053clench
conch124620073_conch
cranch133613533cranch
craunch1464443craunch
crunch13349503crunch
dainty105311473dainty
dance85223133da_nce
danish101513793danish
ditch115015093_ditch
drench12369593drench
dunch115316263_dunch
each95530583ea__ch
eparch13258423epa_rch
evince1137763evince
faience1237513faience
fain75840563fain__
fainer94717243fainer
faint85837063fain_t
faints94818783faints
faith115620853fai_th
fancy134615483fa_ncy
fiance11310743fiance
filch134813323_filch
finca104714503_finca
fitch134816873_fitch
flench144010813flench
flitch14928173flitch
french143511213french
gain56042163gain__
gained84617463gained
gainer74117493gainer
gainly1049323gainly
gains65729513gain_s
gainst74914693gainst
glitch12286353glitch
glunch1255353glunch
haint85436323hain_t
haints94417583haints
hance105424153ha_nce
hatch135719593ha_tch
hawfinch2242033hawfinch
hitch134515473_hitch
hunch136416213_hunch
ich86227743__i_ch
itch95619173__itch
jacinth1954603jacinth
jaunce15367433jaunce
kain85334293kain__
kainit10414483kainit
kains96125643kain_s
kench145513923_kench
laic65931563lai_c_
laichs115110893lai_chs
laics76419253lai_cs
laigh95515923lai_gh
lain46146283lain__
laith85722103lai_th
lance75126723la_nce
larch105919793la_rch
latch104620463la_tch
launce8469183launce
lich96230843_li_ch
lunch104917243_lunch
lynch13468983_lynch
mach116134473ma__ch
main65345503main__
mainly11411493mainly
mains75635093main_s
manche133515103ma_nche
manic94629433manic_
manics103919933manics
march125622893ma_rch
match125621103ma_tch
milch124413373_milch
mince95325233_mince
mincy125817413_mincy
munch124917103_munch
nance74721843na_nce
nancy105214923na_ncy
natch105018223na_tch
nautch1144813nautch
ninth8314583_ninth
pac79054083pa__c_
paca85132243pa__ca
pace86345773pa__ce
pacha126518063pa__cha
pacing114522753pacin_g
pack125535443pa__ck
pacs85842183pa__cs
pact86648723pa__ct
pacy115328683pa__cy
padnag1036073padnag
paginal10269493paginal
paging104020403pagin_g
pagings114411063pagings
pah88853593pa___h
paid75737483pai__d
paik105726803pai__k
paiked135113433paiked
paiks114719853pai_ks
pail66141833pai__l
pails75833063pai_ls
painful1246403painful
paining103920243paining
painted104214633painted
painter93814563painter
pair66031513pai__r
paired95017523paired
pairs75325833pai_rs
paisa76021073pai_sa
paisan84417073paisan
paisas84317493paisas
paise75028333pai_se
palace104516913palace
paling93530133palin_g
palings103915823palings
palish114718273palish
pan58466443pa_n__
panache1458423panache
panchax2134983pa_nchax
panda85022613pa_nda
pandy115021173pa_ndy
pane64950283pa_n_e
paned85437183pa_ned
panel76023623pa_nel
panes76148693pa_nes
pang75336283pa_n_g
panga85323533pa_nga
pangs84628663pa_ngs
panicky1833853panicky
panicle11129983panicle
panicum1346393panicum
panier84425503panier
panini8314273panini
panino8315683panino
panne76623653pa_nne
panned94123433panned
panner84224763panner
pannes85522853pannes
panocha1444983panocha
panoche1456383panoche
pans65855723pa_n_s
pansy105717973pa_nsy
pant66061253pa_n_t
panto76129413pa_nto
pants76536923pa_nts
panty105929303pa_nty
papacy1547493papacy
paraph13311263paraph
pardah123412823pardah
pariah114320583pariah
paring94236493parin_g
parings104219213parings
parish115022353parish
parritch1543543parritch
pash95638133pa__sh
pataca10311193pataca
patchy16509573pa_tchy
patency1466313patency
path99134913pa__th
patience1247513patience
patin76832853patin__
patina86022193patin_a
patinae95414403patinae
patinas96318523patinas
patine85328123patin_e
patined105114783patined
patines95225763patines
patins87528783patin_s
paunched1645523paunched
paunches1568173paunches
pavin105623203pavin__
paving124519743pavin_g
pavings134011633pavings
pavins114919663pavin_s
pawing124519553pawin_g
pawn94625303pawn__
pawned124513283pawned
pawnee113115403pawnee
pawner114212923pawner
pawnor11357243pawnor
pawns108818133pawn_s
paying123722163payin_g
paynim1337363paynim
peach125422493p_each
pech116125453p__ech
pein65834943pein__
peined94918843peined
peins76128063pein_s
pence94924453p_ence
perch124518833p_erch
pian66136093pian__
pianic103714123pianic
piano76118713pian_o
pianos84315933pianos
pians75126963pian_s
pic76046823p_i_c_
pica85831493p_i_ca
pice84641093p_i_ce
pick125933813p_i_ck
pics85633913p_i_cs
piece96717993p_iece
piing85218833piin_g
pin57066723p_in__
pina65842633p_in_a
pinas75434453p_inas
pincer104019173p_incer
pinched153812453p_inched
pincher143812713p_incher
pinches144117933p_inches
pine67755713p_in_e
pined85935323p_ined
pines76048863p_ines
piney105727503p_iney
ping75943593p_in_g
pingo87122713p_ingo
pings85830883p_ings
pink107039383p_in_k
pinko115618253p_inko
pinks115729383p_inks
pinky145823403p_inky
pinna75320183p_inna
pinny105222063p_inny
pinon76024533p_inon
pinot78737293p_inot
pins65558453p_in_s
pint66963173p_in_t
pinta75727053p_inta
pinto75625753p_into
pints75936223p_ints
pinup9612883p_inup
piny911838353p_in_y
pisco96314983p_isco
pish96127913p_i_sh
pitchy16479673p_itchy
pith95432693p_i_th
plaice10311553plai_ce
plain74823303plain__
plained103812233plained
plainer93811983plainer
plainly1236473plainly
plains85019593plain_s
plaint85323203plain_t
plaints94012053plaints
planche14299753planche
planish12412053planish
pleach134211243pleach
pliancy1435593pliancy
plica9613373pli_ca
plink115219123plin_k
plinks124913263plinks
plinths1236123plinths
poach124917863p_oach
poind84217913poin_d
poinds93511143poinds
point75338733poin_t
pointe84619313pointe
points85618533points
pointy114913283pointy
ponce95222513p_once
poncho133310123p_oncho
pooch124815303p_ooch
porch125918623p_orch
pouch124617083p_ouch
pounce105214093pounce
prance104318573prance
preach133613923preach
price93725413pri_ce
prick134317503pri_ck
pricy124814563pri_cy
princes113015143princes
princox1843573princox
prink114719673prin_k
prinks124315383prinks
print74837463prin_t
prints84320103prints
psych1554963p_sych
punchy16398523p_unchy
punish111411503punish
putsch1334933putsch
pyic116915823pyi_c_
pyin96823233pyin__
pyins105815863pyin_s
quaich2047693quai_ch
quench2036633quench
quince173910133quince
quitch2036413quitch
rain46251733rain__
rained75024603rained
rains55140233rain_s
rainy85921083rain_y
rance75028513ra_nce
rancho114310853ra_ncho
ratch104221363ra_tch
raunchy15284313raunchy
rich97025543_ri_ch
saice75424053sai_ce
sain45551293sain__
sained75424243sained
sains55639973sain_s
saint55147073sain_t
saints65122423saints
saith85826553sai_th
samech13277033samech
sangh95517453sa_ngh
sauch104918773sa_uch
since75024173_since
sinh76238043_sin_h
smirch1356463smirch
snitch11357943snitch
spinach1435393spinach
squinch2134833squinch
stanch113812373stanch
staunch1244273staunch
stench114111163stench
stich104117923sti_ch
stitch11419103stitch
switch14458913switch
synch135011793_synch
tach96132753ta__ch
tain45548073tain__
tains54936323tain_s
taint55542283tain_t
taints64520533taints
tench105620003_tench
tinct76126233_tinct
trench114211613trench
twitch14406163twitch
vain75233003vain__
vainer93714573vainer
vainly1258503vainly
vanish121513203vanish
vinca105315163_vinca
wain75840193wain__
wains86930863wain_s
watch135617063wa_tch
wench136214783_wench
which163910083whi_ch
wich125724743_wi_ch
wince105220883_wince
witch134517563_witch
wrench14439353wrench
yince105214253_yince
zilch19438123_zilch
zinc156819093_zinc_
zincs165312933_zincs
zincy195413513_zincy

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.1561145455.1
2DLD Change Limit1127164106.20318171.2
3Display Results4104100.1233333.3
 (SQL Overall)1786914106.48227567.3
 
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.