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

180 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
amotion971047(None) 
amotions1069841amotions
emotion9711301emotion
motion85217551_motion
abortion1048102abortion
action84719682a_ction
adoption1146082adoption
alation72920552alation
ambition1246562ambition
amnion84812052am_nion
amorino9310252amorino
auction93412932auction
demotion1169072demotion
emoticon1273792emoticon
emotions10610282emotions
lotion65716522_lotion
morion86217732_morion
motions94215002_motions
notion64516582_notion
potion84519572_potion
remotion10410232remotion
ablation10312433ablation
ablution1047223ablution
abolition1147053abolition
aboon74918703abo__on
abortions1147783abortions
abutilon1043083abutilon
acetin8314693aceti_n
acromion1246063acromion
actin74922553a_cti_n
actinon9459463a_ctinon
actions94218513a_ctions
adaption1145643adaption
addition1096893addition
ademption1443493ademption
admonition1344443admonition
adnation9310783adnation
adoptions1245783adoptions
adoration10311313adoration
aeolian738623aeolian
aeonian738353aeonian
aeration8319933aeration
agnation9311713agnation
alations82518893alations
aloin55227413alo_i_n
amain74922893am_ai_n
amative12311733amative
amatol838683amat_ol
amazon1736823am_azon
ambitions1346343ambitions
amidin94015663amidi_n
amin66042253am__i_n
amino75425503am__ino
amities9317383amities
ammino1069883am_mino
amnio75218053am_nio_
amnions93710913am_nions
amnios84912523am_nios
amoeban1144913amoeban
amorini9310353amorini
amorist9317643amorist
amortise10428513amortise
amortize1987743amortize
amosite9313163amosite
animation11313683animation
anion55028813a__nion
antlion7310293antlion
apportion1347003apportion
auctions104012143auctions
audition979173audition
aviation11312743aviation
avion84218343a__vion
avocation14168993avocation
axion1211316913a__xion
azotic172711623azoti_c
azotise1637073azotise
azotize1537073azotize
bastion9312473bastion
biotin83215823bioti_n
biotron937293biotron
camion103917193cam__ion
campion133011413cam_pion
caption113513693caption
carotin92216713caroti_n
cation83925503_cation
caution93013513caution
chorion12311763chorion
coition9314313coition
commotion1576983commotion
cooption1288333cooption
cotton8312993_cotton
croton84415453crot_on
damnation1238403damnation
demotions1258443demotions
devotion1256763devotion
diction102313053diction
edition8310853edition
elation73620453elation
elution72913823elution
emetin8613463emeti_n
emodin9310353emodi_n
emoticons1353783emoticons
emoting10313563emoting
emotional1146663emotional
emotive1239193emotive
enation73419233enation
erosion7311103erosion
faction122613333faction
fiction122010733fiction
gonion73612833_gonion
gumption1343983gumption
halation11313853halation
himation1339743himation
kation104315683_kation
lampion11278303lam_pion
lavation1139973lavation
laxation1538423laxation
lection92614863lection
logion76013723_logion
lotions74614763_lotions
mansion9611543mansion
martian93514683martian
martin84122523marti_n
matin75132853_mati_n
matron83918313_matron
mattin84416633matti_n
mention9314373mention
minion83416243_minion
monition10311723_monition
moon67140813_mo__on
morions94014633_morions
moron76925423_mo_ron
morrion959003_morrion
motif10519673_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
natation81513933natation
nation64322803_nation
notions74014483_notions
onion54320973__onion
option83612713_option
oration71617713oration
ovation101510023ovation
paction112713963paction
palmation13310223palmation
photon1111514823phot_on
plosion939113plosion
portion9615493portion
potions93417423_potions
promotion1359503promotion
proton84318893prot_on
rampion11298583ram_pion
ration64226013_ration
remotions1149703remotions
ronion63315643_ronion
ruction93611613ruction
sanction1049533sanction
section92515663section
solion6616383_solion
station72717243station
stotin63215043stoti_n
suction93713043suction
taction93213023taction
tampion11298663tam_pion
taxation1537993taxation
tompion11247103tompion
tuition738823tuition
unction9310663unction
vacation131911893vacation

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.1531167915.0
2DLD Change Limit1340271806.06322105.7
3Display Results1801800.0802250.0
 (SQL Overall)1786911806.29628381.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.