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

185 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
elevon97795(None) 
eleven988301eleven
elevons1067571elevons
alevin92511512alevin
devon95113682_devon
elevens1066802elevens
lemon75618182_lemon
levin84816412_levin
levo76820062_levo_
pleon74216382ple_on
aeon45634613_ae_on
aileron739833aileron
alencon945733alencon
aleuron757383aleuron
alevins102110573alevins
alexin132311483alexin
belon73924113_belon
beton76022063_beton
bevor101510813_bevor
blazon1736763blazon
celadon1036913celadon
chevron1575783chevron
claxon1536583claxon
clean75420413cle_an
clever114611533clever
clevis1158963clevis
clon66232483cl__on
cloven114211513cloven
crepon1039943crepon
daemon9279593daemon
deletion92011973deletion
demeton1037683demeton
demon86520313_demon
devons104512253_devons
ebon66821103__ebon
echelon1276163echelon
eikon939463e_ikon
elain55324703el_ain
elan46734243el__an
elation73620453elation
elbow10117713el_bow
elect74327033ele_ct
election102015353election
elector93313263elector
electron102611413electron
elects83315003elects
elegant8311503elegant
elegit71212893elegit
elegy939303ele_gy
element9317803element
elemi7312503ele_mi
elemis8312383elemis
elevate101110373elevate
elevation1239233elevation
elevator1146713elevator
eleventh1443773eleventh
elfin84312463el_fin
elision72311103elision
eloign7456983eloign
eloin55923203el_oin
elusion72310953elusion
elution72913823elution
eluvia936133eluvia
elver85216243el_ver
elvers93814983elvers
elves85118743el_ves
elytron1045463elytron
emerod9139213emerod
emetin8613463emetin
enliven1034903enliven
enteron7313343enteron
envoi878023e_nvoi
envoy1156723e_nvoy
eon36052083__e_on
epigon937963epigon
erelong835593erelong
erenow937373erenow
etalon648973etalon
ethion938813ethion
etymon1134693etymon
eudemon1064753eudemon
even75222273__even
exon117116803__exon
eyen76223663eye__n
felon84619293_felon
flacon1138633flacon
flagon1037983flagon
flavin1239303flavin
flavone1335523flavone
flavor1236663flavor
fleuron1055573fleuron
flexion1735073flexion
flexor1634503flexor
glean65818203gle_an
glen56027203gle__n
gluon6311223gl_uon
guenon736403guenon
hegemon1345173hegemon
helicon1237643helicon
hellion10311143hellion
hereon93914363here_on
heron85025503_heron
jeon116821443_je_on
jeton124815403_jeton
keelson1153993keelson
kelson1038153kel_son
kelvin13117323kel_vin
klaxon1733853klaxon
laevo849363laevo_
lean46345243_le_an
learn55322663_learn
leaven95013073leaven
leben7314853_leben
legion75712983legion
legong836963_legong
leman75622603_leman
lemons84415053_lemons
lemony11419553_lemony
leno47331393_leno_
lenos56024863_lenos
leone55018823_le_one
lepton82510803lepton
lesion64715063lesion
lesson64412043lesson
leukon1036143leukon
lev66139423_lev__
leva77020713_lev_a
levant9314493_levant
levee84023813_levee
level84116553_level
lever85125163_lever
levins94514653_levins
levis85818553_levis
levy106418503_lev_y
lion46334453_l_ion
liven85021733_liven
logon615922313_logon
loon47344793_l_oon
melon73922083_melon
melton8311553mel_ton
meson74118313_meson
nelson638423nel_son
neon47026423_ne_on
odeon6411483ode_on
olefin937583olefin
olein5316003ole_in
oleo46630483ole_o_
oleos55419683ole_os
operon8811773operon
paeon74819493pae_on
pelon74423213_pelon
peloton938743peloton
peon65635243_pe_on
pereion9312053pereion
pereon83517453pere_on
pleons84213343ple_ons
pleuron976343pleuron
plexor1535253plexor
pluton838853pluton
recon75624243_recon
redon65424883_redon
relearn747973relearn
relevant1149243relevant
releve95116403relev_e
releves103914973releves
relievo10425773relievo_
relievos11374383relievos
replevin1365053replevin
rewon86920583_rewon
seton55223543_seton
seven84118313_seven
skeleton1244473skeleton
sloven9389633sloven
sweven1235983sweven
telamon936523telamon
telecom1146823telecom
telegony1244223telegony
teleman959573teleman
telemen9310173telemen
teleran7510183teleran
telethon1146003telethon
telson6310293tel_son
tenon53320513_tenon
uneven957913uneven
xenon122612453_xenon

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 Limit1127161855.34321096.0
3Display Results1851850.0464021.7
 (SQL Overall)1786911855.76530995.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.