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 “eruption” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
eruption104704(None) 
eruptions1146761eruptions
abruption1343972abruption
eduction1169052eduction
elution72913822elu_tion
equation17310482equation
erection102115512erection
erudition1046172erudition
erupting11218442erupting
eruptive1345792eruptive
fruition11106102fruition
irruption1143782irruption
ruction93611612_ruction
abruptions1443843abruptions
adaption1145643adaption
adoption1146083adoption
aeration8319933aer_ation
arcuation11410583arcuation
auction93412933_auction
caption113513693_caption
caution93013523cau_tion
cooption1288343cooption
corruption1455373corruption
creation102816513creation
deception1448323deception
decryption1843733decryption
deduction1377083deduction
disruption13135733disruption
duration9312693duration
edition8310853e_dition
education12310203education
eductions1268773eductions
egestion946863egestion
egyptian1441893egyptian
ejection172510043ejection
elation73620453e_lation
election102015353election
elusion72310953elu_sion
elutions82513053elu_tions
emotion9711303e_motion
emulation11312393emulation
emulsion1045923emulsion
enation73419233e_nation
encryption1753123encryption
equations1839493equations
erasion7311963er_asion
erections112515213erections
erepsin937383erepsi_n
erosion7311113er_osion
eructation1248333eructation
eructing112110173eructing
eruditions1146103eruditions
erupt74220063erupt___
erupted10207163erupt_ed
eruptible1342923eruptible
eruptives1443853eruptives
erupts8348903erupt__s
evection131910833evection
eviction13228683eviction
evulsion1155063evulsion
exaction1738953exaction
exception2046853exception
exemption2064943exemption
exertion15310083exertion
exudation1787693exudation
fraction1359483fraction
friction1347913friction
fruitions12106113fruitions
grunion835433gru_nion
gumption1343983gumption
irruptions1243893irruptions
krypton1643283krypt_on
nervation12610243nervation
option83612713__option
oration71617713or_ation
perception1688613perception
perdition1249013perdition
preoption1348083preoption
pupation1269503_pupation
ration64226013_r_ation
reaction10612603reaction
reception13410323reception
reduction1259903reduction
relation82619773relation
remotion10410233remotion
resumption14124733resumption
reunion737673reu_nion
ructions102811683_ructions
rutin55421343_ru_ti_n
seduction1266983seduction
seriation9318063seriation
serration9414063serration
sorption1037513sorption
suction93713043_suction
traction10412683traction
trunnion843273trunnion
tuition738823_tuition
vernation12311083vernation

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 Filter1786911461620.420425454.8
2DLD Change Limit146162986.42322756.0
3Display Results98980.0303266.7
 (SQL Overall)178691986.87325999.0
 
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.