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

362 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
legions8461178(None) 
legion75712981legion_
lesions73813871lesions
logions86211291logions
regions83613471regions
begins94415302begi_ns
flexions1844412flexions
lagoons839252lagoons
lections102413842lections
legations102711922legations
leggins9259472leggins
leghorns1244902leghorns
legists899592legists
legits71313002legi_ts
legong836962leg_ong
legongs934542leg_ongs
lemons84415052le_mons
leptons91910432leptons
lesion64715062lesion_
lessons73811022lessons
leukons1135752leukons
levins94514652levi_ns
lexicons1743892lexicons
lions55923212l__ions
logins77820642logi_ns
logion76013722logion_
logons79818172log_ons
lotions74614762lotions
region74614902region_
actions94218513actions
aegis6316783aegi__s
aegises8311373aegises
aeons57624653ae__ons
agios65919863_agio_s
agons66423783_ag_ons
alations82518893alations
alencons1045483alencons
aleurons867013aleurons
alevins102110573alevi_ns
alexins141910663alexi_ns
algins74816433algi_ns
amnions93710913amnions
anions64123033_anions
argons75018203arg_ons
avions94114393_avions
axions134713483_axions
basions94213953basions
beacons11410733beacons
beckons15279143beckons
begin85117353begi_n_
begirds1134883begirds
begone9512133beg_one
begroans1145503begroans
belons84119413be_lons
benisons1037043benisons
betons84919553be_tons
bunions92210473bunions
camions113916133camions
cations94524143cations
cessions1039853cessions
cions75222853__cions
clarions10310493clarions
cogons96818113cog_ons
deacons10310393deacons
deigns8389983de_igns
deletions102610933deletions
demons94917723de_mons
designs9328313designs
devious1138523devious
devons104512253de_vons
durions839963durions
ebons74316093_e_bons
egis56520653_egi__s
egises7312493_egises
egos55821653_eg_o_s
eikons1038503_eikons
elains64919853elai_ns
elations83719123elations
elections112414973elections
elegiacs1144053elegiacs
elegies81312903elegi_es
elegises9128823elegises
elegists9128113elegists
elegits8149343elegi_ts
elegizes18137103elegizes
elevons1067573elevons
elfins94810943elfi_ns
elisions82210423elisions
eloigns8425353eloigns
eloins65419383eloi_ns
elusions82610083elusions
elutions82513053elutions
eons46638713_e__ons
epigons1048183_epigons
ethions1038483ethions
exons125813343_e_xons
fagins10513863fagi_ns
fanions103713073fanions
feigns10407753fe_igns
felons93615763fe_lons
fermions1336203fermions
flagons1137973flag_ons
flections14239213flections
fleurons1155343fleurons
flexion1735073flexion_
fluxions1844423fluxions
fugios1037583fugio_s
fusions1039153fusions
gabions102410053gabions
gins55543953__gi_ns
gipons9389603__gipons
girns64516803__girns
girons75014373__girons
goons65326773__goons
hagdons1258523hagdons
hegemons1444893hegemons
hegiras1136103hegiras
helicons1337613helicons
helios94816633helio_s
hellions11310023hellions
hemins113417573hemi_ns
heriots10312063heriots
heroins103518013heroins
herons94820543he_rons
inions64417003_inions
ions46737853___ions
jetons134512613je_tons
jettons1437273jettons
kations114013663kations
kelsons1137323kelsons
ladinos8389963ladinos
ladrons83813193ladrons
lagans75717783lag_ans
lagoon7410483lagoon_
lampions12277973lampions
lapins84520683lapi_ns
lardons83914493lardons
latinos73613803latinos
layins93817653layi_ns
leadens83610983leadens
leans55536253le__ans
learns65513743le_arns
leavens10409303leavens
lebens8310093le_bens
lectins92515003lectins
lection92614863lection_
lectors93415773lectors
legals73412733leg_als
legates82917683legates
legation92412933legation_
legators92811033legators
legatos82711183legatos
legend837693leg_end
legends936073legends
legers74518313leg_ers
leges64427293leg__es
leggin8268593leggin_
legging103912643legging
leggings11316193leggings
leghorn1146223leghorn
legible1035833legible
legibly1344623legibly
legionary1343653legionary
legist71315253legi_st
legit61323503legi__t
legless838013legless
legman949653legman_
legmen939343legmen_
legroom1076093legroom
legrooms1185413legrooms
legs56133693leg___s
legumes1036633legumes
legumins1144993legumins
legwork1545663legwork
legworks1645373legworks
leis45739603le_i__s
lemans85316393le_mans
lemon75618183le_mon_
lemony11419553le_mony
lenient7313843lenient
lenis56326863leni__s
lenites7818443lenites
lenitions939473lenitions
lenos56024863le_no_s
lens46146493le___ns
lentos65317403lento_s
leone55018823le__one
leones64417723le__ones
leprous938843leprous
leptins92412693leptins
lepton82510803lepton_
lesbians1043603lesbians
lesbos837403lesbo_s
lesioned936903lesioned
lessens7409383lessens
lesson64412043lesson_
lessors73610523lessors
letdowns1243483letdowns
leucins938103leucins
leukon1036143leukon_
leviers103510343leviers
levies93919863levi_es
levin84816413levi_n_
levis85818553levi__s
lewis85315843lewi__s
lewises1039133lewises
lewissons1241743lewissons
lexicon1643903lexicon_
lexis125916033lexi__s
liaisons844293liaisons
liens56525503l__iens
ligans76817733lig_ans
ligations102111993ligations
lignans8398853lignans
lignins84010493lignins
ligroins946823ligroins
limns75718393l__imns
linins65922143lini_ns
linns56123333l__inns
linos55631503l__inos
lins47059053l__i_ns
lion46334443l__ion_
lipins85016883lipi_ns
logans76319063log_ans
logics95711123logi_cs
login66025003logi_n_
logon615922313log_on_
logos67225333log_o_s
loins56728423l_oi_ns
loons55731723l__oons
lorgnons943993lorgnons
lotion65716523lotion_
luging83915293lugi_ng
lupins84514463lupi_ns
lyricons1343583lyricons
lysins94610953lysi_ns
magians10310753magians
medians103214213medians
megatons11279703megatons
megilps1233563megilps
melons84117713me_lons
meltons9410923meltons
mentions10312893mentions
merinos9311983merinos
merlons93311273merlons
mesons83215843me_sons
mignons1037863mignons
minions93314623minions
morions94014643morions
motions94215003motions
nasions73112383nasions
nations74720563nations
negations102811963negations
negatons9299273negatons
negroni846843negroni
negronis947273negronis
nektons1136393nektons
nelsons738003nelsons
neocons936913neocons
neons55818683ne__ons
neurons7410453neurons
newtons1036813newtons
notions74014483notions
olefins1037493olefi_ns
oleins6313523ole_i_ns
onions64016433_onions
options93810603options
peins76128063pe_i_ns
pekins121812233peki_ns
pennons939713pennons
pensions10311693pensions
peons75327183pe__ons
pepinos1137693pepinos
pereions10310853pereions
pereons92815003pereons
perigons11310083perigons
periods10312243periods
perrons93115483perrons
persons93717013persons
pigeons1039183pigeons
pinions93413603pinions
pions75826393__pions
pleons84213343ple__ons
plosions1038023plosions
potions93417423potions
prions84317783_prions
rations74123433rations
reagins84215643reagi_ns
reasons72514943reasons
reckons13269653reckons
recoins94019243recoins
recons84922993re_cons
redons75222183re_dons
regains84316583regains
regilds996673regilds
regimens11469233regimens
regimes104514743regimes
regina75317143regi_na
reginas85614063reginas
regional9438783regional
regionals10286413regionals
regius7311923regi_us
regives115014213regives
regloss8218023regloss
reglows11288843reglows
regrows11269153regrows
reigns74811753re_igns
reins56234563re_i_ns
rejoins143111383rejoins
religions1086603religions
renins64526453reni_ns
repins84924313repi_ns
resigns83910963resigns
resins64528773resi_ns
reunions837273reunions
rewins95020823rewi_ns
ronions73313343ronions
scions82612243_scions
seasons72614233seasons
sections102714703sections
segnos73610443segno_s
segos64919483seg_o_s
seniors73413623seniors
serins64029673seri_ns
serious73616283serious
sermons9311783sermons
sessions839723sessions
setons64620173se_tons
sextons143710413sextons
solions7513753solions
talions7314113talions
tedious838443tedious
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
tensions8310223tensions
ternions838813ternions
testons7313563testons
tiglons837343tiglons
tigons74112263tig_ons
trigons84312093trigons
turions7311573turions
unions64216753_unions
vegans103910853veg_ans
vegies104314273vegi_es
veins84620493ve_i_ns
venins93816703veni_ns
venisons1136133venisons
versions11310353versions
virions1039873virions
visions10311023visions
waggons1235503waggons
wagons103911213wag_ons
wanions104011373wanions
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
wigeons1136983wigeons
xenons132710483xe_nons
yogins105114103yogi_ns
zeins144715393ze_i_ns

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.423422437.4
2DLD Change Limit1340273626.71619956.4
3Display Results3623620.1562320.5
 (SQL Overall)1786913627.29524495.0
 
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.