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

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

67 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
sustentations135478(None) 
sustentation1255021sustentation_
ostentations1246122_ostentations
assentations1245833_assentations
augmentations1654123augmentations
ostentation1146963_ostentation_
ostentatious1252863_ostentatious
segmentations1655593segmentations
substantiations1772793substantiations
sustentative15133103sustentati_ve
abstentions1364364absten__tions
alimentations1594994alimentations
assentation1146184_assentation_
attenuations1243804_attenuations
attestations1244464_attestations
augmentation1554394augmentation_
auscultations1553054auscultations
catenations1348364_caten_ations
cementations1659014_cementations
contestations1547734contestations
dentations11413634___dentations
destinations13412664destin_ations
detestations1347584_detestations
dispensations1655484dispensations
dissertations1465894dissertations
distentions12178844disten__tions
extenuations1945084_extenuations
fermentations1856274fermentations
fomentations1746794_fomentations
fustigations1644764fust_igations
gustations1147234gus___tations
guttations1145594gu_t__tations
indentations1347884_indentations
instantiations1493534instantiations
lamentations1495984_lamentations
lustrations1147624lust__rations
mentations12312584___mentations
orientations1246914_orientations
outstations1145344ou_t_stations
pigmentations1854094pigmentations
placentations17103634placentations
potentiations1555184_potentiations
presentations1548134presentations
protestations1555814protestations
pustulations14115624pust_ulations
rustications1448564rust_ications
sedimentations1754414sedimentations
segmentation1556004segmentation_
sensations1059854__s_ensations
septentrions1472204septent_rions
sternutations1353754__sternutations
subgenerations1752514subgenerations
subornations1446144suborn_ations
substantiation1673154substantiation_
substations1348244su__bstations
substitutions1553284subst_itutions
subventions1674844subven__tions
sulfonations1543924sulfon_ations
supernations14410874su_pernations
superstations15208144superstations
supinations1348834su_pin_ations
supplantations1862524supplantations
suspensions1353844suspen__sions
suspirations1445854sus_pirations
susurrations1244334sus_urrations
systemizations2864084systemizations
unostentatious1461124unostentatious

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 Filter178691950240.360496363.9
2DLD Change Limit95024674.73320076.9
3Display Results67670.076881.6
 (SQL Overall)178691675.16934569.7
 
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.