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

504 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
merrier9261230(None) 
marrier93817521marrier
terrier73414961terrier
aerier64823152ae_rier
barrier94017732barrier
beerier93613022beerier
berried103714042berried
berries94423552berries
burrier93613542burrier
carrier93619582carrier
currier93316692currier
decrier102713552decrier
dernier83011942dernier
derriere936042derriere
derries83124622derries
eerier64320022_eerier
farrier103514882farrier
fernier103110812fernier
ferried113411522ferried
ferries103521082ferries
firrier103410122firrier
furrier103513642furrier
germier10309542germier
harrier104417752harrier
herbier1239592herbier
herried113514452herried
herries104025072herries
hurrier103412932hurrier
jerkier18407272jerkier
jerries143817512jerries
kerries113317912kerries
learier73415662learier
leerier73111502leerier
marlier92614772marlier
marrer83716672marr_er
married104715302married
marriers103312472marriers
marries93825282marries
mealier93015902mealier
meatier93214612meatier
mercer105214202me_rcer
mercies113817562mercies
merer75126232me_r_er
merger95016472me_rger
merriest10311472merriest
merrily1238632merrily
meshier123410852meshier
messier93412922messier
metier83517692me_tier
mirier83918352m_irier
mirkier13319052mirkier
moorier93113072moorier
murkier133110262murkier
murries94118672murries
nerdier83110352nerdier
nervier10298832nervier
parrier93717652parrier
perkier133813122perkier
perries93226602perries
serried82513962serried
serries73925352serries
smearier1036952smearier
sorrier72313722sorrier
tarrier74323172tarrier
tearier73815612tearier
terriers84210812terriers
terries73425612terries
verier94620962ve_rier
vernier102711272vernier
wearier103613282wearier
worrier102311672worrier
aerie54634603ae_rie_
aeried74221863ae_ried
aeries64737783ae_ries
airier64619363_airier
amercer1146373ame_rcer
angrier839023angrier
arriver10117793_arriver
artier63419733_artier
barkier133814483barkier
barmier114313043barmier
barnier93213673barnier
barriers104311883barriers
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
bearer85323913bear_er
beefier12329093beefier
belier84423563be_lier
bendier103111413bendier
blearier1037333blearier
blurrier1035153blurrier
brevier1237763brevier
brier74527403__brier
burier84324653_burier
burlier93514413burlier
burrer83718473burr_er
carried103717153carried
carriers103614203carriers
carries94328013carries
charier124317903charier
charrier1378683charrier
cheerier1348003cheerier
cherries131812973cherries
chertier1387873chertier
corkier133114303corkier
cornier93017083cornier
corrie83621213corrie_
corries94026783corries
courier93617873courier
crepier1139733crepier
crier74724463__crier
curdier103312613curdier
curlier93314183curlier
currie84317253currie_
curried103313653curried
curriers103410753curriers
curriery13326163curriery
curries93723163curries
curvier123110663curvier
dearer74822803dear_er
dearie73319813dearie_
dearies83526273dearies
debrief1337613debrief
decreer10269123decreer
decried112612853decried
decriers11299733decriers
decries103319803decries
deedier93011593deedier
defier105118653de_fier
deifier113013123deifier
denier74420693de_nier
depriver1446293depriver
derbies103016053derbies
derider93214973derider
deriver114213913deriver
derrick1435803derrick
derrieres1044813derrieres
derringer1144583derringer
derris73615273derri_s
derrises93012783derrises
descrier1157623descrier
desirer8310783desirer
destrier9311823destrier
dewier104013463de_wier
dirtier83312093dirtier
dorkier122810023dorkier
drearier9297923drearier
drier64423963__drier
durrie73713253durrie_
durries83817353durries
earlier72612743earlier
earner63617223_earner
easier64218463_easier
edgier8469723_edgier
eelier64216463_eelier
eerie55228533_eerie_
elmier839813_elmier
emeries91620023emeries
emptier1187603emptier
envier939673_envier
eraser64216333_eraser
erred65915673_err_ed
erring73816473_erring
error53712233_err_or
eyrie88117833_eyrie_
eyries93816813_eyries
eyrir8359653_eyri_r
farriers113610743farriers
farriery14295403farriery
fearer94820183fear_er
feirie939553feirie_
fennier10339253fennier
ferlie92814053ferlie_
ferlies103216693ferlies
ferrel92810203ferr_el
ferret93021173ferr_et
ferreter1136543ferreter
ferric1139993ferri_c
ferrite103312753ferrite
ferrites112312823ferrites
fierier103511193fierier
forkier144311583forkier
frier85225843__frier
furriers11369483furriers
furriery14395673furriery
furriner11267283furriner
furzier19318093furzier
geekier12286393geekier
gemmier12337383gemmier
girlier8289523girlier
glarier84112203glarier
gorier73719373_gorier
gorsier83811073gorsier
gurries83515953gurries
hairier103111053hairier
hardier114721543hardier
harried113815533harried
harriers113712433harriers
harries103525493harries
headier113212953headier
hearer94323643hear_er
heartier1139093heartier
heavier13429423heavier
hedgier12367873hedgier
heftier1337203heftier
hempier14319003hempier
henries102718283henries
herder104516463he_rder
herring113615873herring
hoarier104211743hoarier
hornier103012453hornier
horrider1236523horrider
horsier103013243horsier
hurried113511043hurried
hurriers11358893hurriers
hurries103919653hurries
jeerer13389933jeer_er
jerker17369043je_rker
jerkies183411583jerkies
jerreed1535203jerreed
jerrid14259143jerri_d
jerrids15277743jerrids
jettier14358693jettier
kerria10339913kerri_a
kerrias11289513kerrias
lardier83518343lardier
larkier113711523larkier
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
learner7319383learner
leavier10319993leavier
ledgier9458493ledgier
leggier9368233leggier
levier94013873le_vier
lorries74518343lorries
malmier113611953malmier
maltier93015483maltier
mangier104114063mangier
manlier92414023manlier
marbler113511673marbler
marblier1256343marblier
marcher143912973marcher
mariner93315993mariner
marker124420393m_arker
marred95421043marr_ed
marrers93414313marr_ers
marrieds11288073marrieds
marring103319543marring
marshier1337593marshier
massier93615223massier
matier84321523m_atier
mazier175013063m_azier
meager94515193me_ager
mealie82519803mealie_
mealies92821933mealies
meander1049973meander
meaner84617843me_aner
meanie83718393meanie_
meanies93620743meanies
measlier1036013measlier
meddler11319953meddler
meeker12359983me_eker
meeter83616503me_eter
megrim1178043megri_m
megrims1276103megrims
meinie82614523meinie_
meinies92516073meinies
meister93114163meister
melder93915813me_lder
melter83520113me_lter
member12258853me_mber
memoir1037213memoi_r
memories121214343memories
memoriter13126573memoriter
memorizer22137633memorizer
menacer112610883menacer
mender93520793me_nder
menhir1136783menhi_r
merceries13410033merceries
mercers114412773me_rcers
mercery14397623me_rcery
merces105720743me_rces
merches144013763merches
mercuries1347253mercuries
merde84320123me_rde_
merdes94518603me_rdes
mere67244443me_r_e_
meres75143573me_r_es
merge84523683me_rge_
merged104214943me_rged
mergee94018133me_rgee
mergees104411233mergees
mergers103813423me_rgers
merges94122483me_rges
merging112711753merging
merino8315093me_rino
merises93421423merises
merit7339183me_ri_t
merited10313853merited
merits8320873me_rits
merle75824373me_rle_
merles85322763me_rles
merlin83916683merli_n
merlins93015803merlins
mermen10813813me_rmen
merriment1358013merriment
merriness1138283merriness
merry104721483merr__y
metamer1139613metamer
meter75130323me__ter
metiers93312843me_tiers
metre74821303metr_e_
metred95315143metr_ed
metres85121563metr_es
metric10314673metri_c
metrics11312363metrics
metrify1535623metrify
metring103215283metring
metrist9317063metrist
meuniere1043233meuniere
mewler113510233me_wler
miffier1537023miffier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512463mincier
mingier103815283mingier
mintier93615993mintier
mirker123712693m_irker
mirror848003mirr_or
mistier93418713mistier
mitier83620663m_itier
moldier103110033moldier
moodier103212203moodier
moonier93714103moonier
mopier103914783m_opier
morrion959003morrion
morris83814723morri_s
morrises10711063morrises
mortiser1078473mortiser
mossier94413813mossier
mothier121910213mothier
motlier92010583motlier
mourner938083mourner
mousier93712463mousier
muckier153411473muckier
muddier114110013muddier
muggier11288943muggier
murder93613783m_urder
murker123715243m_urker
murre74821073murr_e_
murres85019043murr_es
murrey114312253murr_ey
murrine9411473murrine
murther1237953murther
mushier123813583mushier
muskier134312723muskier
mussier93314353mussier
mustier94017953mustier
muzzier17326553muzzier
mythier15125183mythier
nearer64618893near_er
nearlier836793nearlier
needier84010623needier
nettier74211813nettier
newsier10147223newsier
onerier7311613onerier
orbier839983_orbier
parried103615723parried
parriers103612903parriers
parries93925843parries
partier93520713partier
peakier134411443peakier
pearler9310363pearler
pearlier1037313pearlier
pearter9412743pearter
peatier94017233peatier
peckier153910523peckier
peerie83617893peerie_
peeries93623023peeries
peppier10268323peppier
percher143313423percher
perdie94718513perdie_
perter84422283pe_rter
peruser93511373peruser
peskier13319113peskier
pestier94317403pestier
pettier94213613pettier
porkier133712343porkier
pornier93413123pornier
premier113515633premier
prier75027763__prier
pursier94012753pursier
purtier93214093purtier
quarrier1736843quarrier
querier16310013querier
readier83117423readier
rearer64928913rear_er
redried93714893redried
redries83721713redries
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
refried113513873refried
refries104419733refries
reifier103414523reifier
relier65826183re_lier
rentier73618223rentier
reorder8239483reorder
replier94214973replier
retirer74715013retirer
retried84419153retried
retries74129073retries
rewriter1137923rewriter
sarkier113413313sarkier
scarier94017873scarier
scarrier10298453scarrier
seamier93114633seamier
searer65432023sear_er
sedgier9399043sedgier
seedier83513633seedier
seepier92912013seepier
serener73415753serener
serer55935503se_r_er
serger73819733se_rger
series64540973se_ries
server94917713se_rver
servicer1335263servicer
sexier13310683se_xier
sherries111812893sherries
skerries12168673skerries
smarmier1235033smarmier
smearer94110403smear_er
smellier1036793smellier
smirkier1444433smirkier
sneerier878103sneerier
sparrier10329143sparrier
spirier93214073spirier
sprier84119063_sprier
spurrier10297683spurrier
starrier8279463starrier
surfier102613543surfier
surlier72915443surlier
tardier859719993tardier
tarried83914133tarried
tarriers83411713tarriers
tarries73324263tarries
tarsier74119253tarsier
tartier74123263tartier
tearer64822903tear_er
techier1269243techier
teenier72611143teenier
tentier73815923tentier
termer85717253te_rmer
terrae62915203terrae_
terreen7257573terreen
terret63425623terr_et
terrifier12126593terrifier
terrify1336353terrify
terrine72517573terrine
terrines82117523terrines
territ63421373terri_t
territs72714493territs
terror63811723terr_or
terser67317823te_rser
testier74015643testier
torrider936163torrider
trier54328533__trier
turfier10249793turfier
varier94619353_varier
vealier102712173vealier
veeries102916883veeries
veinier10269583veinier
verditer1236223verditer
verger104315693ve_rger
verifier14159203verifier
verniers11227843verniers
verser94516963ve_rser
warier93722893_warier
warrior1045363warrior
wartier103413913wartier
wearer94319403wear_er
wearied112911803wearied
wearies103020223wearies
webbier1445423webbier
wedgier12428273wedgier
weedier113810623weedier
weenier103210803weenier
weepier12319273weepier
weirder1144923weirder
wennier10318603wennier
wherried15175013wherried
wherries14179023wherries
wirier94215553_wirier
wordier112511203wordier
wormier12278763wormier
worried11308693worried
worriers11257813worriers
worries104117133worries
wrier84521753__wrier
yearner10336873yearner
zestier163010223zestier

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340275048.00016753.4
3Display Results5045040.2332163.1
 (SQL Overall)1786915048.38921300.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.