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

211 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
emotion971130(None) 
amotion9710471amotion
demotion1169071demotion
emoticon1273791emoticon
emotions10610281emotions
motion85217551_motion
remotion10410231remotion
amotions1069842amotions
demotions1258442demotions
devotion1256762devotion
edition8310852edition
elation73620452elation
elution72913822elution
emetin8613462emeti_n
emodin9310352emodi_n
emoticons1353782emoticons
emoting10313562emoting
emotional1146662emotional
emotive1239192emotive
enation73419232enation
erosion7311112erosion
lotion65716522_lotion
mention9314372mention
morion86217732_morion
motions94215002_motions
notion64516582_notion
potion84519572_potion
remotions1149702remotions
abortion1048103abortion
action84719683_action
ademption1443493ademption
adoption1146083adoption
aeration8319933aeration
alation72920553alation
ambition1246563ambition
amnion84812053am_nion
amorino9310253amorino
auction93412933auction
bastion9312473bastion
biotin83215833bioti_n
biotron937293biotron
caption113513693caption
cation83925503_cation
caution93013523caution
chorion12311773chorion
coition9314313coition
commotion1576983commotion
cooption1288343cooption
cotton8312993_cotton
cremation13511643cremation
croton84415453crot_on
decoction1447523decoction
delation92318083delation
deletion92011973deletion
demeton1037683demet_on
demolition1376983demolition
demonian1147713demonian
demotic12412343demoti_c
demotics1338753demotics
demoting12311423demoting
demotist11311843demotist
devotions1356593devotions
diction102313053diction
eclosion1046893eclosion
ecotone938583ecot_one
editions9310403editions
eduction1169053eduction
egestion946863egestion
egotism1038353egotism
egotist8411273egotist
ejection172510043ejection
elations83719123elations
election102015353election
elision72311103elision
elocution1145673elocution
eloign7456983elo_ign
eloin55923203elo_i_n
elusion72310953elusion
elutions82513053elutions
elytron1045463elytron
emanation11910783emanation
embryon1474063embryon
emersion1047733emersion
emetic10614453emeti_c
emetics11610723emetics
emetine9712943emetine
emetins9812643emetins
emission1047673emission
emodins1039433emodins
emote75421193emot__e
emoted94614923emot_ed
emoter85415193emot_er
emoters94712873emoters
emotes84620283emot_es
empoison1243843empoison
emptied1297393emptied
emptier1187603emptier
empties11712243empties
emptily1445813emptily
emptins1179403emptins
emulation11312393emulation
emulsion1045923emulsion
enations83316903enations
eobiont959943e_obiont
eolian6312593e_olian
eonian6311833e_onian
eosin55220923e_osi_n
equation17310483equation
erasion7311963erasion
erection102115513erection
erosions8310343erosions
erotic82620273eroti_c
erotica92811513erotica
erotics91914153erotics
erotism9312303erotism
erotize16311663erotize
eruption1047043eruption
ethion938813e_thion
evasion1036753evasion
evection131910833evection
eviction13228683eviction
evocation142010293evocation
evolution12117093evolution
exaction1738953exaction
exciton1646083exciton
exemption2064943exemption
exertion15310083exertion
exotic153112653exoti_c
exotica16257603exotica
exotics16229193exotics
exotism1638123exotism
extortion1646723extortion
faction122613333faction
fetation11613143fetation
fiction122010733fiction
gelation93014433gelation
gemmation1445963gemmation
gonion73612833_gonion
gumption1343983gumption
hematin121516023hemati_n
himation1339753himation
kation104315683_kation
kenotron1244463kenotron
lection92614863lection
legation92412933legation
lenition8310083lenition
logion76013723_logion
lotions74614763_lotions
matin75132853_mati_n
matron83918313_matron
melton8311553melt_on
mentions10312893mentions
mesotron1045383mesotron
mestino9411643mestino
metopon11137073metopon
minion83416243_minion
monition10311723_monition
moon67140813_mo__on
morions94014643_morions
moron76925423_mo_ron
morrion959003_morrion
motif10519683_moti_f
motifs1139673_motifs
motile83818343_motile
motional1058673_motional
motioned1137453_motioned
motioner1037593_motioner
motive113112143_motive
motmot10311073_motmot
motor75317293_mot_or
motto76119513_motto_
mottos84615243_mottos
mouton8410853_mouton
muton73817003_mut_on
mutton8510453_mutton
nation64322803_nation
negation92913023negation
notions74014483_notions
onion54320973__onion
option83612713_option
oration71617713oration
ovation101510023ovation
paction112713963paction
peloton938743pelot_on
petition10711753petition
photon1111514833phot_on
plosion939113plosion
portion9615493portion
potions93417423_potions
prenotion1149173prenotion
promotion1359503promotion
proton84318893prot_on
ration64226013_ration
reaction10612603reaction
relation82619773relation
retortion949673retortion
ronion63315643_ronion
ruction93611613ruction
section92515663section
sedation9312453sedation
sedition939333sedition
solion6616383_solion
station72717243station
stotin63215063stoti_n
suction93713043suction
taction93213023taction
tompion11247103tompion
tuition738823tuition
unction9310663unction
venation11513503venation
vexation1838783vexation

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 Limit1340272117.40618097.1
3Display Results2112110.0802637.5
 (SQL Overall)1786912117.63923391.9
 
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.