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

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

57 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
supersubtleties197118(None) 
supersubtlety2061663supersubtlet__y
supersubtle1553684supersubtl___e_
subtleties1245355_____subtleties
superathletes1863445super_athlet_es
superhumanities2271635superhumanities
supersecrecies2062305supers_ecrecies
superstates1349555supers__t_at_es
supersymmetries2481325supers_ymmetries
hypermobilities2763446hypermobilities
impersonalities1963676impersonalities
operabilities17510056_oper_abilities
personalities1556476__personalities
personalties1485156__personal_ties
reversibilities2084156reversibilities
sensibilities1557376s__ensibilities
sensualities1265946s__ensu_alities
separabilities1847346separ_abilities
severabilities1947436sever_abilities
superableness17127526super_ab_leness
superactivities2283776superactivities
superathlete1753506super_athlet_e_
superbnesses1695566super__b_nesses
supercabinets1953856supercabinet__s
supercities15411566super____cities
superettes1249746super_____ettes
superfamilies2073466superfamil__ies
superfluidities21181786superfluidities
superfluities1854146super__fluities
supergravities2072446super_gravities
superiorities1556326super__iorities
superlatives1756576super____latives
superlies11314556super____l__ies
supermajorities2672016supermajorities
supernumeraries19111356supernumeraries
supernutrition1673626supernu_trition
supernutritions1763436supernu_tritions
superovulates1863566super_ovulat_es
supersales12411246supers__al___es
supersalesmen1761946supers__alesmen
supersaturates16104426supers_aturates
supersedes1379426supers____e_des
supersellers1453926supers_elle__rs
supersexes1978046supers____e_xes
supersleuths1753006supers___leuths
superspies1449296supers_____pies
superstate1249836supers__t_at_e_
superstation14168626supers__t_ation
superstations15208146supers__t_ations
superstimulates1982346superstimulat_es
superstition14166876supers__t_ition
superstitions15176786supers__t_itions
superstitious15175166supers__t_itious
superstores13117956supers__t__ores
superstrikes1855866supers__t_rikes
supersurgeons1662496supersu_rge_ons
supersystems1962426supersyst_e__ms

Search took 9 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.376475242.0
2DLD Change Limit95024577.62612460.5
3Display Results57570.0461239.1
 (SQL Overall)178691578.04822203.2
 
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.