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 “eruptions” 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
eruptions114676(None) 
eruption1047041eruption_
abruptions1443842abruptions
eductions1268772eductions
elutions82513052elu_tions
equations1839492equations
erections112515212erections
eruditions1146102eruditions
erupting11218442erupti_ng
eruptives1443852eruptives
fruitions12106112fruitions
irruptions1243892irruptions
ructions102811682_ructions
abruption1343973abruption_
adaptions1245223adaptions
adoptions1245783adoptions
aerations9317903aer_ations
arcuations1249343arcuations
auctions104012143_auctions
captions123813223_captions
cautions103313183cau_tions
cooptions13107763cooptions
corruptions1555173corruptions
creations112614543creations
deceptions1547863deceptions
decryptions1943613decryptions
deductions1467133deductions
disruptions14125683disruptions
durations10311463durations
editions9310403e_ditions
educations1339233educations
eduction1169053eduction_
egestions1046703egestions
egyptians1551423egyptians
ejections18249963ejections
elations83719123e_lations
elections112414973elections
elusions82610083elu_sions
elution72913823elu_tion_
emotions10610283e_motions
emptins1179403e_mpti_ns
emulations12310943emulations
emulsions1145343emulsions
enations83316903e_nations
encryptions1852963encryptions
equation17310483equation_
erasions8310983er_asions
erection102115513erection_
erepsins1037443erepsi_ns
erosions8310343er_osions
eructations1347233eructations
eructing112110173eructi_ng
erudition1046173erudition_
eruptible1342923eruptible
eruptive1345793erupti_ve
erupts8348903erupt___s
evections142510693evections
evictions14228623evictions
evulsions1254573evulsions
exactions1838923exactions
exceptions2146863exceptions
exemptions2164833exemptions
exertions1639763exertions
exudations18107073exudations
fractions1449103fractions
frictions1448033frictions
fruition11106103fruition_
grunions945353gru_nions
gumptions1443773gumptions
irruption1143783irruption_
kryptons1743223krypt_ons
nervations1359483nervations
options93810603__options
orations81515803or_ations
perceptions1798193perceptions
perditions1348873perditions
preoptions1447643preoptions
pupations1338123_pupations
rations74123433_r_ations
reactions11711713reactions
receptions1449743receptions
reductions1359583reductions
relations92418333relations
remotions1149703remotions
resumptions15154593resumptions
reunions837273reu_nions
ruction93611613_ruction_
ructious10277083_ructious
rutins63818393_ru_ti_ns
seductions1366873seductions
seriations10316683seriations
serrations10313093serrations
sorptions1137123sorptions
suctions103012903_suctions
tractions11511623tractions
trunnions943003trunnions
tuitions838283_tuitions
vernations13310333vernations

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641987.11020905.9
3Display Results98980.0462130.4
 (SQL Overall)178691987.31224438.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.