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 “sanitary” 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
sanitary114675(None) 
cavitary1664962cavitary
insanitary1352762insanitary
janisary1843622janisary
janizary2742482janizary
laniary1068012lani_ary
sagittary1342202sagittary
salivary1444732salivary
salutary1145112salutary
sanctuary1442182sanctuary
sanitaria947062sanitaria
sanitarily13104472sanitarily
sanitate8612042sanitate
sanity9316202sanit__y
solitary1146502solitary
unitary1038612_unitary
unsanitary1352002unsanitary
vanitory1445732vanitory
angary10311323_an_gary
animacy1446103_animacy
antiar6317173_antiar_
antiars7314623_antiars
apiary113910383_api_ary
ariary94114203_ari_ary
aviary12338413_avi_ary
banditry1444123bandit_ry
basilary1345063basilary
canary11314693can__ary
datary10310243da__tary
dignitary1442463dignitary
fantasy1336153fan_tasy
gantry103810113gan_t_ry
gyniatry1541863gyniatry
janissary1951823janissary
janitor1436483janitor_
janitors1536853janitors
kantar10311153kan_tar_
kantars11310033kan_tars
lactary1237843la_ctary
laminary13337253laminary
laniard868523lani_ard
lanital7310913lanita_l
lanitals837723lanitals
lapidary1454093lapidary
limitary1344933limitary
mandatary1543243mandatary
manuary1237773man_uary
military1347233military
monetary1346523monetary
monitory1347853monitory
nitery94412173__nitery
notary92310713__notary
pantry115014103pan_t_ry
planetary1443903planetary
punitory1345603punitory
saintly1039343saint_ly
salary9515213sa__lary
sancta839833sancta__
sanctify1644493sanctify
sanctity1345593sanctity
sandbar10108193sandbar_
sandbars11108783sandbars
sangar73617683san_gar_
sangars83116253san_gars
sanguinary1451833sanguinary
sanitarian1047443sanitarian
sanitaries1049913sanitaries
sanitarium1254623sanitarium
sanitated1068993sanitated
sanitates9611733sanitates
sanities81219773sanities
sanitise81511813sanitise
sanitize171410083sanitize
sanitoria946663sanitoria
sansar63613393san_sar_
sansars73313913san_sars
santera7311303san_tera
santero7311133san_tero
santir6315253san_tir_
santirs7312963san_tirs
santur6311273san_tur_
santurs7310763san_turs
satara6315533sa__tara
satay84718463sa__ta_y
sectary1238273s_ectary
seminary1398103seminary
senary93716073sen__ary
sentry92912053sen_t_ry
simitar936733simitar_
simitars1046483simitars
sitar54820543s__itar_
sitars65417593s__itars
solidary1245103solidary
stannary1144613stan_nary
tanistry1144543tanistry
tantara72410823tan_tara
unitard838003_unitard
vanity12311933vanit__y

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 Filter1786911461620.403443402.0
2DLD Change Limit146162986.98620922.1
3Display Results98980.0462130.4
 (SQL Overall)178691987.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.