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

89 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
salivations144873(None) 
salivation1349811salivation_
salvations1338131sal_vations
salivating1447442salivati_ng
salivators13135752salivat_ors
saltations10310622sal_tations
salutations1147642salutations
salvation1239292sal_vation_
sanitations11410842sanitations
satiations10312112sati_ations
solvations1336832sol_vations
validations1547242validations
activations1669263activations
agitations11310063_agitations
alations82518893_al__ations
alienations1147883_alienations
animations12312193_animations
aspirations1348993aspirations
aviations12311553_avi_ations
calcinations1647933calcinations
calibrations1645153calibrations
capitations1549853capitations
captivations1945343captivations
cavitations1647843cavitations
ciliations121111003cili_ations
clavations1546183_clavations
cultivations1745593cultivations
derivations15611493derivations
desalinations14410183desalinations
elevations1338633_elevations
estivations1449273estivations
filiations13119093fili_ations
foliations1399943foli_ations
habitations1646883habitations
halations12312393hal__ations
lallations1038743lal_lations
laminations1339803laminations
lavations1238973__lavations
libations112510443__libations
ligations102111993__ligations
marinations13411273marinations
motivations1647093motivations
nasalizations2248703nasalizations
navigations1545203navigations
obligations1446143obligations
paginations1447753paginations
palliations1347723palliations
palmations1438733pal_mations
palpations1437653pal_pations
palpitations1645523palpitations
passivations1764433passivations
patinations13411003patinations
plications14310493_plications
privations15310103_privations
radiations11311923radi_ations
realizations21415533realizations
salinizations2258423salinizations
salivates1239293salivat__es
salivator12136113salivat_o_r
saltation9312003sal_tation_
salutation1048903salutation_
salvational1443713sal_vational
salvationism1763113sal_vationism
salvationist1554403sal_vationist
sanitation10412043sanitation_
satiation9313433sati_ation_
saturations1148573saturations
scalations1239783scal__ations
seriations10316683seri_ations
sibilations13127933sibilations
siltations1038553sil_tations
solations9814623sol__ations
solmizations2346633solmizations
solvation1237773sol_vation_
sonications1349953sonications
spallations1356103spal_lations
spoliations1347693spoli_ations
starvations1445053starvations
striations10312793stri_ations
stylizations2445933stylizations
sublimations1646083sublimations
sulcations1289583sul_cations
sulfations13107813sul_fations
supinations1348833supinations
titivations1446263titivations
validation1448413validation_
vallations1339093val_lations
valuations1348783val_uations
variations13310773vari_ations

Search took 6 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 Filter1786911216330.406440125.6
2DLD Change Limit121633895.31322893.5
3Display Results89890.0461934.8
 (SQL Overall)178691895.76530995.8
 
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.