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

35 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
superambitious207250(None) 
overambitious2061833_overambitious
superadditions1863403superadditions
superstitious15175163super_stitious
superaddition1763464superadditio_n
supercautious1753924super_cautious
supercilious1664534super__cilious
superpositions18145264superpositions
superstitions15176784super_stitions
unambitious1571914_u__nambitious
ambitious1344615_____ambitious
subreptitious1792265su_breptitious
superannuations1763805superannuations
superatoms1448395supera___t_oms
superbitches2152635super__bitches
supercities15411565super__citi_es
superfamilies2073465superfam_ili_es
superfetations1975065superfetations
superfluities1854145superfluiti_es
superiorities1556325superioriti_es
superluxurious2371265superluxurious
supermicros1753755super_m_icro_s
superminis1448555super_m_ini__s
supernations14410875super__nations
supernutritions1763435supernutritions
superposition17135595superpositio_n
superscriptions2163345superscriptions
superstations15208145super_stations
superstition14166875super_stitio_n
superstitiously2072565super_stitiously
superventions18125785super_ventions
supervisions1755035super__visions
suppositious1653055sup__positious
supposititious1871255supposititious
surreptitious1571855su_rreptitious

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 Filter178691950240.360496363.9
2DLD Change Limit95024356.56314478.7
3Display Results35350.0301166.7
 (SQL Overall)178691356.95325699.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.