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

95 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
sanitations1141084(None) 
sanitation10412041sanitation_
agitations11310062_agitations
animations12312192_animations
capitations1549852capitations
cavitations1647842cavitations
habitations1646882habitations
insanitations13136472insanitations
salivations1448732salivations
saltations10310622sa_ltations
salutations1147642salutations
sanitarians1146242sanitarians
sanitating1149652sanitati_ng
sanitizations2248552sanitizations
satiations10312112sati_ations
sonications1349952sonications
agitation10311223_agitation_
animation11313683_animation_
annotations1146883annotations
aspirations1348993aspirations
aviations12311553_avi_ations
capitation14311363capitation_
cavitation1549133cavitation_
citations11312503__citations
cogitations1448903cogitations
cunctations1576153cunctations
denotations1239853denotations
dentations11413633den_tations
dubitations1456673dubitations
equitations2047443equitations
excitations2049003excitations
gravitations1644763gravitations
habitation1547913habitation_
habituations1743113habituations
hesitations1448543hesitations
imitations1259963_imitations
incitations13310883incitations
initiations11410723_initiations
insanitation12127183insanitation_
invitations1449053invitations
ionizations2049893ionizations
irritations1147833irritations
jactations1936893ja_ctations
jactitations2145013jactitations
lactations1239423la_ctations
laminations1339803laminations
levitations1448293levitations
limitations1348183limitations
marinations13411273marinations
meditations1449333meditations
mentations12312583men_tations
natations91412493__natations
navigations1545203navigations
nictations1278313__nictations
nidations1039213__nidations
nitrations10312033__nitrations
notations91512973__notations
nutations91411763__nutations
paginations1447753paginations
palpitations1645523palpitations
patinations13411003patinations
plantations1347473plan_tations
punctations1585353punctations
quantitations2263363quantitations
radiations11311923radi_ations
reanimations1468783reanimations
recitations13314203recitations
salinizations2258423salinizations
salivation1349813salivation_
saltation9312003sa_ltation_
salutation1048903salutation_
salvations1338133sa_lvations
sanctions1138873san__ctions
sanitarian1047443sanitarian_
sanitaries1049913sanitari_es
sanitariums1353433sanitariums
sanitates9611733sanitat__es
sanitization2149153sanitization_
satiation9313433sati_ation_
saturations1148573saturations
sensations1059853sen_sations
seriations10316683seri_ations
sibilations13127933sibilations
siltations1038553s_iltations
sinuations1039413sin_uations
situations1038433s__ituations
sonication12411183sonication_
stations82415223s___tations
striations10312793stri_ations
substations1348243substations
supinations1348833supinations
syndications18104473syndications
validations1547243validations
variations13310773vari_ations
visitations1447673visitations

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 Filter1786911216330.406440125.6
2DLD Change Limit121633955.76621094.9
3Display Results95950.0601583.3
 (SQL Overall)178691956.23228673.1
 
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.