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

170 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
amotions106984(None) 
amotion9710471amotion_
emotions10610281emotions
motions94215001_motions
abortions1147782abortions
actions94218512a_ctions
adoptions1245792adoptions
alations82518892alations
ambitions1346342ambitions
amnions93710912am_nions
auctions104012142auctions
demotions1258442demotions
emoticons1353782emoticons
emotion9711302emotion_
lotions74614762_lotions
morions94014642_morions
motion85217552_motion_
notions74014482_notions
potions93417422_potions
remotions1149702remotions
ablations11311513ablations
ablutions1146603ablutions
abolitions1246653abolitions
abortion1048103abortion_
abutilons1142963abutilons
acetins9313173aceti_ns
actinons10389453a_ctinons
actins86321103a_cti_ns
action84719683a_ction_
adaptions1245223adaptions
additions1186333additions
ademptions1543383ademptions
admonitions1444243admonitions
adnations1039753adnations
adoption1146083adoption_
adorations11310243adorations
aerations9317903aerations
agnations10310033agnations
alation72920553alation_
aloins65022203alo_i_ns
amatols938183amat_ols
amazons1836653am_azons
ambition1246563ambition_
ambitious1344613ambitious
amidins103713103amidi_ns
amins75534323am__i_ns
amities9317383amiti_es
amnion84812053am_nion_
amnios84912523am_nio_s
amorini9310353amori_ni
amorino9310253amori_no
amorists10411333amorists
amorous9311133amo_rous
amortises1178823amortises
amortizes2087283amortizes
amosites10311233amosites
animations12312193animations
anions64123033a__nions
antlions839193antlions
apportions1446283apportions
auction93412933auction_
auditions1078753auditions
aviations12311553aviations
avions94114393a__vions
avocations15168683avocations
axions134713483a__xions
azotises1737603azotises
azotizes1636853azotizes
bastions10411693bastions
biotins93114453bioti_ns
biotrons1037243biotrons
camions113916133cam__ions
campions143511293cam_pions
captions123813223captions
carotins102315583caroti_ns
cations94524143_cations
cautions103313183cautions
chorions13310663chorions
coitions10312853coitions
commotions1686843commotions
cooptions13107763cooptions
cottons9312193_cottons
crotons93714373crot_ons
damnations1337083damnations
demotion1169073demotion_
devotions1356593devotions
dictions111812673dictions
editions9310403editions
elations83719123elations
elutions82513053elutions
emetins9812653emeti_ns
emodins1039433emodi_ns
emoticon1273793emoticon_
emoting10313563emoti_ng
emotional1146663emotional
emptins1179403empti_ns
enations83316903enations
erosions8310343erosions
factions133013063factions
fictions132410743fictions
gumptions1443773gumptions
halations12312393halations
himations1438803himations
kations114013663_kations
lampions12277973lam_pions
lavations1238973lavations
laxations1637623laxations
lections102413843lections
logions86211293_logions
lotion65716523_lotion_
mansions1069793mansions
martians103111613martians
martins93322063marti_ns
matins84527783_mati_ns
matrons93517633_matrons
mattins93316143matti_ns
mentions10312893mentions
minions93314623_minions
monitions11310883_monitions
moons75331003_mo__ons
morion86217733_morion_
morons84919543_mo_rons
morrions1077673_morrions
motifs1139673_moti_fs
motiles93317433_motiles
motional1058673_motional
motioned1137453_motioned
motioner1037593_motioner
motioners1146583_motioners
motives123611893_motives
motmots1166133_motmots
motors84616603_mot_ors
mottoes93412193_mottoes
mottos84615243_motto_s
moutons9410313_moutons
mutons84314363_mut_ons
muttons949283_muttons
natations91412493natations
nations74720563_nations
notion64516583_notion_
onions64016433__onions
options93810603_options
orations81515803orations
ovations11149263ovations
pactions122613503pactions
palmations1438733palmations
photons123814433phot_ons
plosions1038023plosions
portions10514413portions
potion84519573_potion_
promotions1448783promotions
protons93118003prot_ons
rampions12248023ram_pions
rations74123433_rations
remotion10410233remotion_
ronions73313343_ronions
ructions102811683ructions
sanctions1138873sanctions
sections102714703sections
solions7513753_solions
stations82415223stations
stotins73213873stoti_ns
suctions103012903suctions
tactions102912423tactions
tampions12358123tam_pions
taxations1636863taxations
tompions12267003tompions
tuitions838283tuitions
unctions1039733unctions
vacations141910553vacations

Search took 9 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 Filter1786911461620.403443402.0
2DLD Change Limit1461621707.67319048.9
3Display Results1701700.0802125.0
 (SQL Overall)1786911708.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.