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

457 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
lotions7461476(None) 
logions86211291logions
lotion65716521lotion_
motions94215001motions
notions74014481notions
potions93417421potions
actions94218512actions
alations82518892alations
amotions1069842amotions
cations94524142cations
coitions10312852coitions
cottons9312192cottons
elations83719122elations
elutions82513052elutions
emotions10610282emotions
kations114013662kations
latinos73613802latinos
lections102413842lections
legions84611782legions
lesions73813872lesions
lions55923212l__ions
lobations11219612lobations
locations112512742locations
locutions11207062locutions
logins77820642logi_ns
logion76013722logion_
logons79818172lo_gons
loins56728422lo_i_ns
loons55731722lo__ons
lotos54724632lot_o_s
lottos64613102lotto_s
morions94014642morions
motion85217552motion_
nations74720562nations
notion64516582notion_
onions64016432_onions
options93810602options
plosions1038022plosions
portions10514412portions
potion84519572potion_
rations74123432rations
ronions73313342ronions
solions7513752solions
ablations11311513ablations
ablutions1146603ablutions
abortions1147783abortions
actinons10389453actinons
actins86321103acti_ns
action84719683action_
adoptions1245783adoptions
alation72920553alation_
aloins65022203alo_i_ns
amnions93710913amnions
amotion9710473amotion_
anions64123033_anions
antlions839193antlions
auctions104012143auctions
avions94114393_avions
axions134713483_axions
basions94213953basions
bastions10411693bastions
batons85519423bat_ons
betons84919553bet_ons
biotins93114453bioti_ns
biotrons1037233biotrons
blousons1054403blousons
bolsons969483bolsons
bonbons1139333bonbons
boons75031913bo__ons
borons85520543bo_rons
bosons85016653bo_sons
bostons9312903bostons
bottoms1136993bottoms
boutons9310783boutons
bunions92210473bunions
buttons9310333buttons
camions113916133camions
captions123813223captions
cation83925503cation_
cautions103313183cautions
chitons122611913chitons
chorions13310663chorions
cions75222853__cions
citrons92913223citrons
clarions10310493clarions
coactions1349743coactions
cocoons11310563cocoons
codons96119463co_dons
cogons96818113co_gons
coigns94410063co_igns
coins75834553co_i_ns
coition9314313coition_
cojoins1638993cojoins
colins85229043coli_ns
colons86028683co_lons
commons13311043commons
conations111318903conations
conins84327233coni_ns
coons76737283co__ons
cooptions13107763cooptions
copious11311963copious
cordons104415763cordons
cortins92421333corti_ns
cosigns1047513cosigns
cotans81317923cot_ans
cotillons1144653cotillons
coting94629253coti_ng
cotton8312993cotton_
cottony1237253cottony
coupons112710563coupons
covins114618063covi_ns
crotons93714373crot_ons
cutins83919983cuti_ns
cytons111710183cyt_ons
delations102616593delations
deletions102610933deletions
demotions1258443demotions
devotions1356593devotions
dictions111812673dictions
dilations102614453dilations
dilutions10248583dilutions
doblons1037043doblons
dobsons1036203dobsons
dominos103210193dominos
donations101112353donations
donjons1536733donjons
dotations101411633dotations
doting84821913doti_ng
durions839963durions
eclosions1146203eclosions
editions9310403editions
elation73620453elation_
elections112414973elections
elisions82210423elisions
elocutions1245963elocutions
eloigns8425353elo_igns
eloins65419383elo_i_ns
elusions82610083elusions
elution72913823elution_
emoticons1353783emoticons
emotion9711303emotion_
enations83316903enations
eobiont959943eobiont
eobionts1043983eobionts
eosins64419163eosi_ns
erosions8310343erosions
ethions1038483ethions
factions133013063factions
fanions103713073fanions
fictions132410743fictions
flatirons1244483flatirons
flections14239213flections
flexions1844413flexions
florins10311643flori_ns
flotations1366873flotations
fluxions1844423fluxions
foins85523383fo_i_ns
foisons1047613foisons
folios93915463folio_s
folious103710733folious
fusions1039153fusions
futons93911513fut_ons
gabions102410053gabions
gelations102513093gelations
globins10278953globi_ns
glonoins955843glonoins
glorious946823glorious
gluttons944273gluttons
godsons966663godsons
gonion73612833gonion_
goons65326773go__ons
gorgons938853gorgons
halations12312393halations
horizons2045463horizons
hotdogs1234453hotdogs
hotrods1148283hotrods
illations9311393illations
inions64417003_inions
introns73515023introns
iodations1039113iodations
iodins74216523iodi_ns
ions46737853___ions
jetons134512613jet_ons
jettons1437273jettons
joins125818413jo_i_ns
kation104315683kation_
kilotons1286313kilot_ons
kotos95717703kot_o_s
kotows13446523kot_ows
ladinos8389963ladinos
ladrons83813193ladrons
lagoons839253lagoons
lampions12277973lampions
lapins84520683lapi_ns
lardons83914493lardons
lateens74210553lateens
latens64620213lat_ens
latices9313763latices
latigoes9306163latigoes
latigos8277243latigos
latina65621143lati_na
latinas74416463latinas
latino64120473lati_no
lattens75014673lattens
lattins74115483lattins
lavations1238973lavations
laxations1637623laxations
layins93817653layi_ns
lectins92515003lecti_ns
lection92614863lection_
legations102711923legations
legion75712983legion_
lemons84415053l_emons
lenitions939473lenitions
leptins92412693lepti_ns
leptons91910433leptons
lesion64715063lesion_
lessons73811023lessons
letdowns1243483letdowns
leukons1135753leukons
levins94514653levi_ns
lexicons1743893lexicons
liaisons844293liaisons
libations112510443libations
liens56525503l__iens
ligations102111993ligations
limns75718393l__imns
linins65922143lini_ns
linns56123333l__inns
linos55631503l__inos
lins47059053l__i_ns
lion46334443l__ion_
lipins85016883lipi_ns
lithops12307253lithops
lithos94212553litho_s
loans56026463lo__ans
lobation102110553lobation_
lobos75921843lo_bo_s
location102113913location_
lochans1248833lochans
locoes85516583lo_coes
locoing102810973locoing
locos75822603lo_co_s
locution10227663locution_
lodens74315063lo_dens
lofting113311313lofti_ng
logans76319063lo_gans
logics95711123logi_cs
login66025003logi_n_
logon615922313lo_gon_
logos67225333lo_go_s
loids66220703lo_i_ds
loin46838723lo_i_n_
loiters74116613loiters
lollops9227443lollops
lomeins969483lomeins
longans84510813longans
loofs85623783lo__ofs
looies65025833looi_es
looing73621043looi_ng
looks95124863lo__oks
looms75124643lo__oms
loon47344793lo__on_
loony86918963lo__ony
loops75723963lo__ops
loos49051123lo__o_s
loosens716310963loosens
looting83019643looti_ng
loots55431423lo__ots
loping93921413lopi_ng
lorans65117603lo_rans
lorgnons943993lorgnons
lories64933043lori_es
loris55329153lori__s
lorises73918593lorises
losing74022873losi_ng
losings82810623losings
lotahs9479873lot_ahs
lotas55926303lot__as
loti46431843loti___
lotic76420673loti__c
lotoses73713653lotoses
lots47652093lot___s
lotters73921063lotters
lottes65322753lot_tes
lotting82917753lotting
lotto55217573lotto__
lotus55718063lot__us
lotuses74011253lotuses
loudens8368053loudens
louies64525103loui_es
louis57322323loui__s
louting83719383louti_ng
loving104416723lovi_ng
lowboys1534213lowboys
lowdowns1543463lowdowns
lowing104623273lowi_ng
lowings113710073lowings
loxing143615273loxi_ng
lunations9310723lunations
lupins84514463lupi_ns
luteins7310103luteins
luteous739273luteous
luting75221753luti_ng
lutings83311053lutings
lutists73810273lutists
luxations1637273luxations
lyricons1343583lyricons
lysins94610953lysi_ns
matins84527783mati_ns
matrons93517633matrons
mentions10312893mentions
minions93314623minions
monitions11310883monitions
moons75331003mo__ons
morion86217733morion_
morons84919543mo_rons
morrions1077673morrions
motifs1139673moti_fs
motiles93317433motiles
motional1058673motional
motioned1137453motioned
motioner1037593motioner
motioners1146573motioners
motives123611893motives
motmots1166133motmots
motors84616603mot_ors
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
mutons84314363mut_ons
muttons949283muttons
nasions73112383nasions
nation64322803nation_
natrons73215663natrons
nitons64614903nit_ons
noons54125283no__ons
notations91512973notations
notices9312283notices
noting74120153noti_ng
notional849403notional
novations12139003novations
noxious1446563noxious
oblations1139373oblations
odeons739023_odeons
odious749933_odious
oleins6313523olei_ns
olios54520853_olio_s
onion54320973_onion_
oniony9369703_oniony
ootids71110353ooti_ds
option83612713option_
orations81515803orations
orisons7310563_orisons
orlons6411013_orlons
otiose639403_otiose
otitis63612343_otitis
ottos54714323_otto_s
ovations11149263ovations
pactions122613503pactions
patins87528783pati_ns
patios85221783patio_s
patrons93818103patrons
pelotons1038913pelot_ons
photons123814433phot_ons
pinions93413603pinions
pions75826393__pions
pitons85319043pit_ons
platoons1038683platoons
pliotrons1144703pliotrons
plosion939113plosion_
plutons938343plut_ons
poisons9310353poisons
polios84019723polio_s
pompons1338553pompons
pontons93315553pontons
pontoons10279313pontoons
poons75430973po__ons
portion9615493portion_
positions11811503positions
postins93721203posti_ns
potations111615073potations
potboys1475273potboys
poteens92910883poteens
pothos114214693potho_s
pottos84615873potto_s
prions84317783_prions
protons93118003prot_ons
putons83515153put_ons
pythons1537363pythons
ration64226013ration_
ratios64922673ratio_s
ratoons73815473ratoons
rattons73815323rattons
regions83613473regions
relations92418333relations
remotions1149703remotions
robins83617453robi_ns
rogations101510823rogations
ronion63315643ronion_
ronyons10258433ronyons
rosins64521863rosi_ns
rotations91613843rotations
rotis56327063roti__s
rotors64917953rot_ors
rotos56027883rot_o_s
ructions102811683ructions
rutins63818393ruti_ns
satins64930483sati_ns
scions82612243_scions
sections102714703sections
setons64620173set_ons
solations9814623solations
solion6616383solion_
solitons849593solitons
solons65120023so_lons
solutions988883solutions
sorptions1137123sorptions
sotols63714473sot_ols
sozins15510793sozi_ns
stations82415223stations
stolons73410243stolons
stotins73213873stoti_ns
suctions103012903suctions
tactions102912423tactions
talions7314113talions
tigons74112263__tigons
tins45251303__ti_ns
titians72710453titians
tompions12267003tompions
tons46553053__t_ons
toons55027533__toons
torsions839183torsions
tortious839023tortious
toting74123793toti_ng
toxins133314283toxi_ns
toyons95512133to_yons
tritons73814883tritons
tuitions838283tuitions
turions7311573turions
unctions1039733unctions
unions64216753_unions
virions1039873virions
visions10311023visions
vocations141911423vocations
volitions1288663volitions
volutions12108393volutions
voting103916033voti_ng
votives13337953votives
voudons1135323voudons
wanions104011373wanions
wontons103310533wontons
yogins105114103yogi_ns
youpons12265983youpons
zloties1639913zloti_es
zonations18139313zonations
zoons144919693zo__ons

Search took 7 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 Limit1340274575.92022639.7
3Display Results4574570.1732641.6
 (SQL Overall)1786914576.49927495.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.