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

380 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
maglevs133469(None) 
maglev1237021maglev_
aglets73915682_aglets
eagles73819162eagle_s
eaglets84111662eaglets
jagless1537102jagless
macles107023222macle_s
mages85036022mag_e_s
magnets10311142magnets
magueys1333942magueys
mailers94420332mailers
mailes84329112maile_s
males75049792ma_le_s
mallees93315972mallees
mallets93318492mallets
malleus92911312malleus
manglers113311902manglers
mangles104021462mangle_s
manless93012932manless
maples104819422maple_s
matless93014042matless
maulers94213302maulers
ables75935543_able_s
agaves104611513_agaves
ageless8310343_ageless
agers65027853_ag_ers
ages55844593_ag_e_s
aggers85817793_aggers
agleam9158623_agleam
aglee65728493_agle_e
aglet65534143_agle_t
agley96917333_agle_y
agrees74915323_agrees
agues64919053_ague_s
aiglets84012913aiglets
alecs76620733_a_lecs
alefs87319663_a_lefs
ales47067103_a_le_s
allees64521483_allees
alleys95113303_alleys
amblers115213563amblers
ambles105121863amble_s
amoles84122193amole_s
amulets939923amulets
anglers84014823anglers
angles74426703angle_s
argles75218483argle_s
arles56735743_arle_s
awless939263_awless
axles125219473_axle_s
bagels95712313bag_els
baggers113915693baggers
baguets1037483baguets
bailees93914383bailees
bailers94221353bailers
baileys12388933baileys
balers85626933ba_lers
bales76250083ba_le_s
ballers94421013ballers
ballets93719513ballets
bangles103617413bangle_s
barless94317003barless
barleys125011843barleys
bawlers124412733bawlers
beagles103212123beagle_s
bogles95020833bogle_s
buglers105115323buglers
bugles94822443bugle_s
cablers114416713cablers
cables104527553cable_s
cablets114216343cablets
cagers95624193cag_ers
cages85936013cag_e_s
callees94117783callees
callers94221963callers
callets93821703callets
calves115119283ca_lves
camlets114314623camlets
capless114312763capless
caplets114914523caplets
carles85435083carle_s
carless95118493carless
caules85927253caule_s
daggers103714913daggers
daggles103611913daggle_s
dagoes85714603dagoe_s
dales66439743da_le_s
dalles74222063dalle_s
danglers103610593danglers
dangles93618423dangle_s
doglegs1034783doglegs
eagers74523683eag_ers
eagle64219483eagle__
eagled82914043eagle_d
eaglet73722583eagle_t
eagres74014573eagre_s
earless74316073earless
eggless935663eggless
fablers124812613fablers
fables114921673fable_s
fallers103917993fallers
fangless1237663fangless
farles96025783farle_s
fatless103212203fatless
flagless1235403flagless
fogless1138193fogless
fugles104715783fugle_s
gables94222333gable_s
gagers84021333gag_ers
gages74529973gag_e_s
gaggers103413663gaggers
gaggles103512593gaggle_s
galeas74618513ga_leas
gales65442483ga_le_s
gallets83517403gallets
galleys11369713galleys
ganevs10456913ga_nevs
gaolers83511563gaolers
gapless10349993gapless
garglers10418263garglers
gargles94214893gargle_s
gasless8319013gasless
giglets93211553giglets
gleds75417893__gleds
glees65027593__glees
glens66519853__glens
gleys96514853__gleys
goglets9379783goglets
guglets9369693guglets
hagglers13326623hagglers
haggles123312483haggle_s
hailers104017263hailers
halers94926913ha_lers
hales85449843ha_le_s
hallels103310133hallels
halves124717093ha_lves
hamlets123211403hamlets
haoles94919803haole_s
hapless123311333hapless
haslets102510863haslets
hatless103813443hatless
haulers104012443haulers
imagers10107763imag_ers
images91411463imag_e_s
imagoes10126403imagoe_s
ingles74420873ingle_s
jagers144415723jag_ers
jaggers164012893jaggers
jailers144114043jailers
janglers16319373janglers
jangles154015683jangle_s
jawless1745653jawless
kales95730983ka_le_s
kayles134712003kayle_s
keglers12277773keglers
ladlers84613573ladlers
ladles74619543ladle_s
lagers74826143lag_ers
laggers94216243laggers
langleys1245103langleys
lawless1037033lawless
legless838013legless
mabes96331533ma_be_s
macers105321273ma_cers
maces97139963ma_ce_s
maches134827233mache_s
mackles154415753mackle_s
macle96127003macle__
macled116718113macle_d
macules114015133macule_s
maddens11359753maddens
madders113513213madders
madness10310073madness
madres93718183madre_s
maes66948403ma__e_s
magalogs1245253magalogs
magdalens1342833magdalens
mage75739133mag_e__
maggots1136563maggots
magians10310753magians
magics115311613mag_ics
magilps1234083magilps
magmas115512503mag_mas
magnet9320663magne_t
magneto1046743magneto
magnetos1146263magnetos
magnums1234683magnums
magots9312363mag_ots
magpies12310363magpies
mags75444533mag___s
maguey1236833mague_y
magus85318753mag__us
mahoes11313103mahoe_s
maidens10349663maidens
maihems1444303maihems
maile75232223maile__
mailed95326753maile_d
mailer84724183maile_r
mailless10248583mailless
maills84215283mail_ls
mails76037783mail__s
maimers113813043maimers
maizes175115733maize_s
makers123921733ma_kers
makes115336853ma_ke_s
malars85020683ma_lars
male66052303ma_le__
malled94626113malle_d
mallee84525593malle_e
mallei84414633malle_i
mallet84433053malle_t
mallows123714323mallows
malls76233433ma_l_ls
malms95021553ma_l_ms
malteds10377603malteds
malts76331753ma_l_ts
mameys13449523ma_meys
mamies104626243mamie_s
mamluks1543313mamluks
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mamzers20409163mamzers
maneless102812343maneless
manes76648963ma_ne_s
mangels103614493mangels
mangers103521263mangers
manges94628953mange_s
mangle93921333mangle__
mangled113615263mangle_d
mangler103215643mangle_r
mangoes104316133mangoe_s
manners93417833manners
manses84225513manse_s
mantels94515043mantels
mantes84430783mante_s
mantles94820703mantle_s
mantlets104611203mantlets
maple95521143maple__
mappers133313783mappers
marblers12319233marblers
marbles114516653marble_s
marcels113212373marcels
mares76457633ma_re_s
marges94525713marge_s
markers133516103markers
markets133314033markets
marled95523163marle_d
marlins93420483marlins
marls75535163marl__s
marrers93414313marrers
marses84827113marse_s
martens93714953martens
martlets103310483martlets
marvels123810093marvels
masers84623453ma_sers
mashers124621053mashers
mashes115030003mashe_s
maskegs14375413maskegs
maskers133913843maskers
masses85028713masse_s
massless10277113massless
masters94628923masters
mastless102610023mastless
mateless102711293mateless
maters85032393ma_ters
mates75251363ma_te_s
mateys115610943ma_teys
matres84522233matre_s
matters94421753matters
mattes85624533matte_s
mauled94817823maule_d
mauler84416713maule_r
mauls76524953maul__s
maumets11369693maumets
mauves113811553mauve_s
mavens114312973ma_vens
mavies114923193mavie_s
maxes145629533ma_xe_s
maybes1339243maybe_s
mayhems1763413mayhems
mazers173917093ma_zers
mazes165632173ma_ze_s
mealless10288363mealless
measles92412753measle_s
meatless103410863meatless
medleys13115333medleys
melees83618083m_elees
merles85322763merle_s
mewlers12288983mewlers
midlegs1156323midlegs
miggles113512033miggle_s
milers84625163m_ilers
miles74645073m_ile_s
millers93621343millers
milles84526563mille_s
millets94216843millets
minglers113011293minglers
mingles103719003mingle_s
moilers93615203moilers
moles74747923m_ole_s
mooleys1236863mooleys
motleys1235683motleys
muggees11338883muggees
muggers113611933muggers
mules75034293m_ule_s
muleys11409643m_uleys
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
naggers93812653naggers
nailers73215893nailers
naleds7469133na_leds
napless93110283napless
oarless73913373oarless
oglers74313183_oglers
ogles65223183_ogle_s
padles95221123padle_s
pagers94423253pag_ers
pages85235073pag_e_s
pales75753803pa_le_s
palets85122313pa_lets
pallets93919303pallets
parles86334403parle_s
parleys125212373parleys
pegless1038053pegless
piglets103311793piglets
ragees74618663rag_ees
rages64539443rag_e_s
raggees93710913raggees
raggles93813283raggle_s
raglans82410133raglans
railers74420663railers
rales54947493ra_le_s
rayless10239003rayless
reglets83512983reglets
sables85026693sable_s
sages65339063sag_e_s
saggers94017083saggers
sailers73822323sailers
saleps85014903sa_leps
sales56055593sa_le_s
sallets73719653sallets
salves94221763sa_lves
samlets93813553samlets
sapless93313443sapless
smogless1134053smogless
tables84524893table_s
tablets94714383tablets
taggers93514193taggers
tailers73720183tailers
talers64628143ta_lers
tales55451373ta_le_s
tanglers92911973tanglers
tangles83920053tangle_s
taxless1436913taxless
tugless837383tugless
vales85434263va_le_s
valets93715623va_lets
valleys13407483valleys
valves124113783va_lves
varlets10411573varlets
wageless1237173wageless
wagers105122203wag_ers
wages95330933wag_e_s
waggers124613083waggers
waggles123812003waggle_s
wailers103916803wailers
walers94824463wa_lers
wales86142833wa_le_s
wallets103914833wallets
wanglers123310033wanglers
wangles113416933wangle_s
warless104015103warless
wayless13308243wayless
wigless11359673wigless
wiglets113411423wiglets
yagers105114533yag_ers

Search took 8 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.406440125.6
2DLD Change Limit1340273806.67020094.0
3Display Results3803800.1402714.3
 (SQL Overall)1786913807.21624763.2
 
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.