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

99 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
sanitation1041204(None) 
sanitations11410841sanitations
agitation10311222_agitation
animation11313682_animation
capitation14311362capitation
cavitation1549132cavitation
habitation1547912habitation
insanitation12127182insanitation
salivation1349812salivation
saltation9312002sa_ltation
salutation1048902salutation
sanitarian1047442sanitarian
sanitating1149642sanitating
sanitization2149152sanitization
satiation9313432sati_ation
sonication12411182sonication
agitations11310063_agitations
animations12312193_animations
annotation1047753annotation
aspiration1249993aspiration
aviation11312743_avi_ation
capitations1549853capitations
cavitations1647843cavitations
citation10314363__citation
cogitation13410083cogitation
cunctation1476913cunctation
denotation11311083denotation
dentation10315243den_tation
dubitation1377333dubitation
equitation1948343equitation
excitation19410173excitation
gravitation1545513gravitation
habitations1646883habitations
habituation1643593habituation
hesitation1349633hesitation
imitation11510853_imitation
incitation12312223incitation
initiation10412103_initiation
insanitations13136473insanitations
invitation13410023invitation
ionization19411273ionization
irritation1048973irritation
jactation1838143ja_ctation
jactitation2045623jactitation
lactation11310813la_ctation
lamination12311223lamination
levitation1349443levitation
limitation1249153limitation
marination12312813marination
meditation13410743meditation
mentation11313983men_tation
natation81513933__natation
navigation1446003navigation
nictation1189273__nictation
nidation9410583__nidation
nitration9313443__nitration
notation81414603__notation
nutation81513103__nutation
pagination1348993pagination
palpitation1546243palpitation
patination12312573patination
plantation1248533plan_tation
punctation1486053punctation
quantitation2153643quantitation
radiation10313393radi_ation
reanimation1359633reanimation
recitation12315943recitation
salinization2158893salinization
salivations1448733salivations
saltations10310623sa_ltations
salutations1147643salutations
salvation1239293sa_lvation
sanction1049533san__ction
sanitaria947063sanitari_a
sanitarians1146243sanitarians
sanitaries1049913sanitaries
sanitarily13104473sanitarily
sanitarium1254623sanitarium
sanitate8612043sanitat__e
sanitated1068993sanitat_ed
sanitates9611733sanitat_es
sanitizations2248553sanitizations
satiations10312113sati_ations
saturation1049803saturation
sensation9510583sen_sation
seriation9318063seri_ation
sibilation12128773sibilation
siltation939213s_iltation
sinuation9310413sin_uation
situation949423s__ituation
sonications1349953sonications
station72717243s___tation
striation9313483stri_ation
substation1248993substation
supination1249883supination
syndication17124963syndication
validation1448413validation
variation12312393vari_ation
visitation1348593visitation

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 Filter1786911406030.1561145455.1
2DLD Change Limit140603997.21619484.9
3Display Results99990.0631571.4
 (SQL Overall)178691997.43524033.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.