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 “suppositories” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

49 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
suppositories177134(None) 
depositories1553163_depositories
repositories1453883_repositories
suppository1852073suppositor__y
depositaries1553114_depositaries
superstores13117954supers_tor_es
supposition1555204supposit__ion
suppositions1654894supposit_ions
suppositious1653054supposit_ious
supposititious1871254supposititious
adiposities1445115adiposit__ies
apospories1446185__apos_pories
appositives1854255_apposit_ives
auditories1146215au___ditories
compositors1754385compositor__s
curiosities1345005curiosit__ies
depositors1344035_depositor__s
dubiosities1443625dubiosit__ies
expositors1943965_expositor__s
fumitories1544065fu___mitories
gulosities1165575gu_losit__ies
monitories1248895___monitories
mucosities1445945mu_cosit__ies
opposites1346145_opposit___es
ovipositors1651575ovipositor__s
pellitories1354855__pellitories
piosities11311725__piosit__ies
pomposities1765715pomposit__ies
puppetries1343885pupp__et_ries
rugosities1144725ru_gosit__ies
serosities10410825s_erosit__ies
sinuosities1145235sinuosit__ies
solitaries10410125s___olitaries
sophistries1653435sophis_t_ries
sparsities1247325s_parsit__ies
spinosities1344955spinosit__ies
sudatories1145685su___datories
summitries1444645su__mmit_ries
supercities15411565supercit__ies
superstore12108695supers_tor_e_
superstrikes1855865supers_t_rikes
supporters1444095suppo_rter__s
supposers1344535suppos__er__s
supposes1238205suppos_____es
suppositional1763065suppositional
suspensories14102085susp_ensories
upcountries1552015_upcount_ries
upholsteries1752465_upholsteries
vomitories1544905___vomitories

Search took 10 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 Filter1786911247900.406440125.6
2DLD Change Limit124790498.57614551.1
3Display Results49490.0331484.8
 (SQL Overall)178691499.01519821.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.