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

294 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
myrtle113573(None) 
myrtles1235731myrtles
dartle73714832dartle
hurtle93512942hurtle
kirtle10309472kirtle
mantle84420922mantle
marble104219102marble
martlet93419152martlet
merle75824372mer_le
mettle83815722mettle
morale85220552morale
mottle84116052mottle
mycele1335852mycele
turtle63213572turtle
aortae65115473aortae
argle65421563_argle
artel56122743_artel
battle85217863battle
beetle8311673beetle
birle75023633bir_le
bottle84916073bottle
burble104617703burble
burgle94815863burgle
bustle84015483bustle
butle75023103_butle
byre95023853byr__e
byrl95716013byr_l_
byrled12437173byr_led
byrls105711233byr_ls
byrnie11348573byrnie
byte96521813by_t_e
cantle84522153cantle
carle74535703car_le
carte75940423cart_e
cartel85022533cartel
castle84918963castle
cattle85118903cattle
chortle124210443chortle
circle1039703circle
curdle95514313curdle
curtly1149283curtly
curule83614123curule
cuttle84113893cuttle
cycle1239523cy_cle
darkle113813943darkle
dartled9409853dartled
dartles84014133dartles
dottle74212503dottle
dyable12308983dyable
eyre75525253eyr__e
eyrie88117833eyr_ie
farle86929243far_le
fartlek1434493fartlek
fertile10311733fertile
ferule93413203ferule
fettle93713123fettle
footle93914383footle
forte86131463fort_e
fytte1138583fy_tte
garble94118453garble
gargle84215463gargle
gentle74014513gentle
girdle82110463girdle
gurgle83912473gurgle
guttle74111973guttle
gyral94412783gyral_
gyrase10508773gyrase
gyrate104912523gyrate
gyre84722763gyr__e
gyrene10227243gyrene
gyrose105310253gyrose
hantle94318203hantle
hirple11158973hirple
hirsle9159573hirsle
hurdle103712793hurdle
hurtled11339593hurtled
hurtles103913753hurtles
hustle93113993hustle
hyte109018943hy_t_e
istle52214713_istle
ixtle12168013_ixtle
jostle13319863jostle
justle133211583justle
kettle104311613kettle
kirtled12287033kirtled
kirtles11309663kirtles
kittle104012173kittle
kyrie123712903kyr_ie
kyte117017763ky_t_e
kythe15509673ky_the
little63312163little
lyrate94112103lyrate
lyre75623793lyr__e
lyttae994713lyttae
mackle143716433mackle
macle96127003m_acle
macule104115273macule
maile75232223m_aile
male66052303m__ale
mangle93921323mangle
mantel84317973mantel
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
maple95521143m_aple
marbled123212113marbled
marbler113511673marbler
marbles114516653marbles
marbly134111933marbly
marcel103714853marcel
mare64759333mar__e
marge85328333mar_ge
marine84230403marine
marl66341623mar_l_
marled95523163mar_led
marls75535163mar_ls
marly106925613mar_ly
marque172410503marque
marse76231153mar_se
mart66865983mart__
marted94425213marted
marten84518263marten
martin84122523martin
martlets103310483martlets
marts77442233mart_s
martyr1135693martyr
marvel113712003marvel
mate65154223m_at_e
matte75626843m_atte
maypole1446383maypole
measle83513223measle
meddle103312763meddle
meetly1138673meetly
meikle1236653meikle
mentee84121293mentee
merde84320123mer_de
mere67244443mer__e
merely111312593merely
merge84523693mer_ge
mergee94018143mergee
merl65830973mer_l_
merles85322763mer_les
merls77423903mer_ls
mestee84523883mestee
mete64438133m_et_e
metre74821303m_etre
mettled103510543mettled
mettles94115023mettles
mickle143715133mickle
middle103414983middle
miggle104012113miggle
mile66352573m__ile
mille75029133m_ille
mingle93518783mingle
miracle1138843miracle
mirage92313653mirage
mire66748233mir__e
mirth106418893mirt_h
mirths114912993mirths
misrule939353misrule
mite66249413m_it_e
mitre75522423m_itre
mizzle16279993mizzle
mobile103613543mobile
module93011033module
mole66251833m__ole
monte75829773mont_e
morae75831193mor_ae
moral75533433moral_
morales93619403morales
morals85324633morals
more67154523mor__e
morel75729093morel_
morelle91210803morelle
morels84820013morels
morgue938113morgue
morose85116243morose
morse76032703mor_se
morsel85815893morsel
mort66758833mort__
mortal84616853mortal
mortals93914003mortals
mortar83812043mortar
mortice11711493mortice
mortise9713533mortise
morts75533563mort_s
morula8710473morula
morulae958963morulae
moste75925083most_e
mostly113110943mostly
mote67048083m_ot_e
motel76623243m_otel
motile83818343motile
motley1139383m_otley
motte75526973m_otte
mottled10409973mottled
mottler94410343mottler
mottles93415803mottles
muckle143413583muckle
muddle103414633muddle
muffle14339643muffle
mule65236973m__ule
mumble123614343mumble
mural75225113mural_
muraled10410833muraled
murals84016763murals
mure65941333mur__e
murine84220023murine
murkly15368303murkly
murre74821073mur_re
murther1237953murther
muscle10310973muscle
mustee83922103mustee
mute65136873m_ut_e
mutule8311423mutule
muzzle16319393muzzle
myceles1435213myceles
myope124010973my_ope
myotic133112313myotic
myotome1445483myotome
myriad1235913myriad
myrica1336833myrica
myrrh1337093myr_rh
myrrhs1443603myrrhs
myself1445593myself
mystic132711643mystic
myth126715433my_t_h
myths135911603my_ths
mythy16568673my_thy
nestle63013953nestle
nettle64514583nettle
orle45630463_or_le
parle75836163par_le
parole84425253parole
partlet92720363partlet
partly116315473partly
pertly115312553pertly
pestle83215843pestle
pettle84116053pettle
pintle83818263pintle
portly114713403portly
pottle84416103pottle
prole74527793_prole
purfle112511183purfle
purple102712683purple
pyre94925553pyr__e
pyrene113210733pyrene
pyrite11913313pyrite
pyrola1139003pyrola
pyrone112714473pyrone
pyrope132810533pyrope
pyrrole1246033pyrrole
rale45050563__rale
rattle64717613rattle
rile45650533__rile
role45851823__role
rootle63214453rootle
rule49938423__rule
rustle63615413rustle
settle63915663settle
smartie9310173smartie
smartly12497433smartly
sortie63621993sortie
spurtle937453spurtle
startle72511123startle
subtle82113433subtle
syrette1037183syrette
systole1035763systole
tartlet72218483tartlet
tartly96014023tartly
tattle64115653tattle
title54721073_title
tittle63613323tittle
tootle62613813tootle
torte55431703tort_e
tortile7313193tortile
turtled8309683turtled
turtler72610323turtler
turtles72914343turtles
tyre75428253tyr__e
tythe115210453ty_the
virile9313433virile
virtue9358673virtue
vittle94711753vittle
warble113516603warble
warsle93112923warsle
warstle10328013warstle
wattle94314213wattle
whortle13335943whortle
wintle94014603wintle
wyle105519383wy__le
wyte106018643wy_t_e
yodle94515043_yodle
yule75725143_y_ule

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 Limit1127162944.56324702.2
3Display Results2942940.0763868.4
 (SQL Overall)1786912945.01535631.3
 
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.