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

345 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
logions8621129(None) 
legions84611781legions
logins77820641logi_ns
logion76013721logion_
logons79818171log_ons
lotions74614761lotions
cogons96818112cog_ons
lagoons839252lagoons
legion75712982legion_
lesions73813872lesions
lions55923212l__ions
logans76319062log_ans
logics95711122logi_cs
login66025002logi_n_
logon615922312log_on_
logos67225332log_o_s
loins56728422lo_i_ns
loons55731722lo__ons
lorgnons943992lorgnons
lotion65716522lotion_
morions94014642morions
motions94215002motions
notions74014482notions
onions64016432_onions
plosions1038022plosions
potions93417422potions
regions83613472regions
ronions73313342ronions
solions7513752solions
yogins105114102yogi_ns
actions94218513actions
agios65919863_agio_s
agons66423783_ag_ons
alations82518893alations
algins74816433algi_ns
aloins65022203alo_i_ns
amnions93710913amnions
amotions1069843amotions
anions64123033_anions
argons75018203arg_ons
avions94114393_avions
axions134713483_axions
basions94213953basions
begins94415303begi_ns
blousons1054403blousons
bogans95714813bog_ans
bogies94724313bogi_es
bolsons969483bolsons
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
bostons9312903bostons
boutons9310783boutons
bunions92210473bunions
camions113916133camions
cations94524143cations
chorions13310663chorions
cions75222853__cions
clarions10310493clarions
cocoons11310563cocoons
codons96119463co_dons
cogitos1037613cogitos
cogon89120903cog_on_
coigns94410063co_igns
coins75834553co_i_ns
coitions10312853coitions
cojoins1638993cojoins
colins85229043coli_ns
colons86028683co_lons
commons13311043commons
conins84327233coni_ns
coons76737283co__ons
copious11311963copious
cordons104415763cordons
cosigns1047513cosigns
cottons9312193cottons
coupons112710563coupons
covins114618063covi_ns
doblons1037043doblons
dobsons1036203dobsons
dogdoms1295423dogdoms
doggone1035683doggone
doggones1135713doggones
dogies85022253dogi_es
dominos103210193dominos
donjons1536733donjons
durions839963durions
eclosions1146203eclosions
elations83719123elations
elisions82210423elisions
eloigns8425353elo_igns
eloins65419383elo_i_ns
elusions82610083elusions
elutions82513053elutions
emotions10610283emotions
eobiont959943eobiont
eobionts1043983eobionts
eosins64419163eosi_ns
epigons1048183epigons
erosions8310343erosions
ethions1038483ethions
fagins10513863fagi_ns
fanions103713073fanions
flagons1137973flag_ons
flexions1844413flexions
florins10311643flori_ns
fluxions1844423fluxions
fogbows1643853fogbows
fogdogs1333263fogdogs
foghorns1544113foghorns
fogies104118063fogi_es
foins85523383fo_i_ns
foisons1047613foisons
folios93915463folio_s
folious103710733folious
fugios1037583fugio_s
fusions1039153fusions
gabions102410053gabions
gins55543953__gi_ns
gipons9389603__gipons
girns64516803__girns
girons75014373__girons
globins10278953globi_ns
glonoins955843glonoins
glorious946823glorious
godsons966663godsons
gogos77516523gog_o_s
gonion73612833gonion_
goons65326773__goons
gorgons938853gorgons
hagdons1258523hagdons
hogans105914313hog_ans
horizons2045463horizons
inions64417003_inions
iodins74216523iodi_ns
ions46737853___ions
isogons8217613isog_ons
joins125818413jo_i_ns
kations114013663kations
ladinos8389963ladinos
ladrons83813193ladrons
lagans75717783lag_ans
lagoon7410483lagoon_
lampions12277973lampions
lapins84520683lapi_ns
lardons83914493lardons
latinos73613803latinos
layins93817653layi_ns
lections102413843lections
legations102711923legations
leggins9259473leggins
leghorns1244903leghorns
legists899593legists
legits71313003legi_ts
legong836963leg_ong
legongs934543leg_ongs
lemons84415053l_emons
leptons91910433leptons
lesion64715063lesion_
lessons73811023lessons
leukons1135753leukons
levins94514653levi_ns
lexicons1743893lexicons
liaisons844293liaisons
liens56525503l__iens
ligans76817733lig_ans
ligations102111993ligations
lignans8398853lignans
lignins84010493lignins
ligroins946823ligroins
limns75718393l__imns
linins65922143lini_ns
linns56123333l__inns
linos55631503l__inos
lins47059053l__i_ns
lion46334443l__ion_
lipins85016883lipi_ns
loans56026463lo__ans
lobations11219613lobations
lobos75921843lo_bo_s
locations112512743locations
lochans1248833lochans
locoes85516583lo_coes
locoing102810973locoing
locos75822603lo_co_s
locutions11207063locutions
lodens74315063lo_dens
lodging103110813lodgi_ng
lodgings11336243lodgings
logan68123283log_an_
logbook1454513logbook
logbooks1544023logbooks
loges66534203log__es
loggats9286453loggats
loggers94616133loggers
loggets9378913loggets
loggias9356783loggias
logging103316803logging
loggings11398233loggings
logia68116603logi__a
logic88217833logi__c
logical1038513logical
logicians1244173logicians
logicise1146113logicise
logier75015733logi_er
logiest82515543logiest
logily1039833logi_ly
loginess9310163loginess
logjams1743583logjams
logo57931763log_o__
logoi69715943log_o_i
logroll844263logroll
logrolls943373logrolls
logs57343113log___s
logways1434513logways
logwood1255573logwood
logwoods1344763logwoods
loids66220703lo_i_ds
loin46838723lo_i_n_
lollops9227443lollops
lomeins969473lomeins
longans84510813longans
longbows1443883longbows
longerons1045893longerons
longhorns1344133longhorns
longicorns1351563longicorns
longies82916553longi_es
longing93915783longi_ng
longings10408563longings
loofs85623783lo__ofs
looies65025833looi_es
looing73621043looi_ng
looks95124863lo__oks
looms75124643lo__oms
loon47344793lo__on_
loony86918963lo__ony
loops75723963lo__ops
loos49051123lo__o_s
loosens716310953loosens
loots55431423lo__ots
loping93921413lopi_ng
lorans65117603lo_rans
lorgnon844423lorgnon_
lories64933043lori_es
loris55329153lori__s
lorises73918593lorises
losing74022873losi_ng
losings82810623losings
lotos54724633lo_to_s
lottos64613103lotto_s
loudens8368053loudens
louies64525103loui_es
louis57322323loui__s
loving104416723lovi_ng
lowboys1534213lowboys
lowdowns1543463lowdowns
lowing104623273lowi_ng
lowings113710073lowings
loxing143615273loxi_ng
luging83915293lugi_ng
lupins84514463lupi_ns
lyricons1343583lyricons
lysins94610953lysi_ns
magians10310753magians
mignons1037863mignons
minions93314623minions
moons75331003mo__ons
morion86217733morion_
morons84919543mo_rons
morrions1077673morrions
motion85217553motion_
moutons9410313moutons
nasions73112383nasions
nations74720563nations
noggins9288453noggins
noons54125283no__ons
notion64516583notion_
noxious1446563noxious
odeons739023_odeons
odious749933_odious
ogives10367913_ogives
oleins6313523olei_ns
olios54520853_olio_s
ologies8615023ologi_es
ologists939443ologists
onion54320973_onion_
oniony9369703_oniony
options93810603options
orisons7310563_orisons
orlons6411013_orlons
pigeons1039183pigeons
pinions93413603pinions
pions75826393__pions
plosion939113plosion_
pogies94123543pogi_es
pogroms1237643pogroms
poisons9310353poisons
polios84019723polio_s
pompons1338553pompons
pontons93315553pontons
poons75430973po__ons
portions10514413portions
potion84519573potion_
prions84317783_prions
rations74123433rations
region74614903region_
religions1086603religions
robins83617453robi_ns
rogations101510823rogations
ronion63315643ronion_
ronyons10258433ronyons
rosins64521863rosi_ns
scions82612243_scions
slogans8407983slog_ans
solion6616383solion_
solitons849593solitons
solons65120023so_lons
sozins15510793sozi_ns
talions7314113talions
tiglons837343tiglons
tigons74112263tig_ons
tompions12267003tompions
toons55027533to__ons
torsions839183torsions
toxins133314283toxi_ns
toyons95512133to_yons
trigons84312093trigons
trogons83410723trog_ons
turions7311573turions
unions64216753_unions
virions1039873virions
visions10311023visions
voudons1135323voudons
waggons1235503waggons
wagons103911213wag_ons
wanions104011373wanions
wigeons1136983wigeons
wontons103310533wontons
yogin98317743yogi_n_
yogini10449143yogi_ni
yoginis11457683yoginis
yogis95617743yogi__s
youpons12265983youpons
zoons144919693zo__ons

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.1531167915.0
2DLD Change Limit1340273457.51617832.2
3Display Results3453450.1262738.1
 (SQL Overall)1786913457.79522923.8
 
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.