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

221 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
enrich113894(None) 
eldrich1354582eldrich
enriched1435862enriched
enricher1345002enricher
enriches1337262enriches
entice81316862entice
erica7316542e_rica
rich97025542__rich
anarch11310393anarch
antic75728863antic_
antick124814583antick
antics84621453antics
anuric8812093anuric_
arch98628443_ar_ch
arnica8310443arnica
auric74521723auric_
baric96125693baric_
bearish123013273bearish
bench125619503ben__ch
birch124914023bir_ch
boric98024223boric_
borsch1336133borsch
brach126123303_brach
brick134618153_brick
brith104924373_brith
caroch13911763caroch
centric11312393centric_
ceric94023093ceric_
ceriph1398463ceriph
crick135118753_crick
curch124415413cur_ch
daric85623113daric_
darics94314113darics
derrick1435803derrick
dreich12377723dreich
each95530583e__ach
earache1239323earache
earing75235483earing
earth85023053ear_th
edict84722283e_dict
eerie55228533eeri_e
eerier64320023eerier
eerily92913563eerily
eldritch1441483eldritch
elfish1267963elfish
elvish1277563elvish
emic86422753e_mic_
enact73525363en_act
enatic8317563enatic_
encash11276943encash
encina8310443encina
encroach1542963encroach
endarch1345443endarch
endash10297123endash
ending83220253ending
endite73817593endite
endive103310473endive
endrin7312403endri_n
endrins8312163endrins
enface112510353enface
engild8107613engild
engine71114863engine
engird8126973engird
engirt71112613engirt
english1137953english
enlace82213233enlace
enlist6417043enlist
enmesh1134893enmesh
enmity1137483enmity
enolic8413353enolic_
enough1045753enough
enrage72715073enrage
enrapt8313013enrapt
enravish1444243enravish
enrichers1444133enrichers
enriching1546153enriching
enrobe86610793enrobe
enrol51014283enr_ol
enroll61110073enroll
enrols61213383enrols
enroot6615993enroot
ensign737523ensign
ensile62616473ensile
enteric9314213enteric_
enterics10312853enterics
entia5318203enti_a
enticed101411193enticed
enticer91510423enticer
entices91616333entices
entire61617703entire
entity9312053entity
entrench13115723entrench
entries71523163entries
enuring8813883enuring
envied1038833envied
envier939673envier
envies9314053envies
enviro936303enviro
enwind10298083enwind
eolith93013903eolith
eparch13258423eparch
epic86921303e_pic_
epics95014283e_pics
epoch1248203e_poch
erect74129333e_rect
ericas8315463e_ricas
erring73816473erring
eruct74022353e_ruct
etch95419143e__tch
ethic101511223ethic_
ethics11169283ethics
etic66123953e_tic_
eunuch1154363eunuch
euripi856083euripi
evict104417143e_vict
exarch18196173exarch
eyrie88117833eyri_e
eyries93816813eyries
eyrir8359653eyri_r
ferric1139993ferric_
fetich1479693fetich
frith115922033_frith
garish104516923garish
generic101310753generic_
generics11118793generics
genic85119393gen_ic_
gentrice1148813gentrice
grinch1238473_grinch
grith95520373_grith
hennish1336863hennish
henries102718283henries
ich86227743___ich
inarch1139163inarch
inch95420823in__ch
indict93115573indict
inrush936513inrush
kench145513923ken__ch
kirsch1532713kirsch
knish1238603kn_ish
laich105920713_laich
larch105919793lar_ch
lentic83515743lentic_
lich96230843__lich
lorica8310443lorica
lurch104814633lur_ch
lyric104512723lyric_
lyrics11357943lyrics
march125622893mar_ch
marish114319053marish
mensch13387083men_sch
merch125417963mer_ch
metric10314673metric_
metrics11312363metrics
myrica1336823myrica
naric76824173naric_
natch105018223_natch
neigh94912383_neigh
nerdish1137103nerdish
newish1237903newish
nice65534713_n_ice
niche105016793_n_iche
nick106627603_n_ick
nigh85220663_n_igh
notch105613323_notch
ogrish1039263ogrish
onrush935343onrush
ontic74418573ontic_
orach105219233_orach
orrice81410163orrice
ostrich1238663ostrich
overrich1648453overrich
parch125123003par_ch
pariah114320583pariah
parish115022353parish
perch124518833per_ch
perish114619063perish
porch125918623por_ch
price93725413_price
prick134317503_prick
pricy124814563_pricy
pyric123815073pyric_
quaich2047693quaich
reprice113212833reprice
rice64942913__rice
rick107334653__rick
scraich1436763scraich
search113312423sear_ch
smirch1356463smirch
snatch114310603snatch
snick114416013sn_ick
snitch11357943snitch
stich104117923_stich
strick124813203strick
strict84821043strict
tench105620003ten__ch
tenrec837513tenrec_
tenrecs936033tenrecs
thrice114311573thrice
torch107420933tor_ch
toric76529313toric_
torics85118353torics
trice75127493_trice
trick115420693_trick
unhitch1543053unhitch
unpick1446903unpick
unrig61711413unri_g
unrigs7159003unrigs
unrip72012863unri_p
unripe82012093unripe
unrips8199453unrips
unwish1239093unwish
uric63624933_uric_
wearish132310153wearish
wench136214783wen__ch
wennish1336243wennish
which163910083_which
wich125724743__wich
wrick144013393_wrick
xenic144114643xen_ic_
xeric144315663xeric_
zenith1839073zen_ith

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.1401276364.3
2DLD Change Limit1127162215.59320153.0
3Display Results2212210.0802762.5
 (SQL Overall)1786912215.81330739.9
 
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.