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

61 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
subphases164576(None) 
subphase1555601subphase_
subbases1239062sub_bases
subchaser1644312subchaser
subchasers1743282subchasers
subleases1148652subleases
sulphates1466172sulphates
anaphases1446533anaphases
apophases1647973apophases
emphases1568353_emphases
phases114618403___phases
prophases16411063prophases
purchases1645633purchases
slipcases1364263slipcases
subbase1139323sub_base_
subbass1138033sub_bas_s
subbasses1345223subbasses
subcastes1387493sub_castes
subcauses1346213subcauses
subclass1246623subclas_s
subclasses1444743subclasses
subclauses1453883subclauses
suberises11813453suberises
subframes1645853subframes
subgrades1346313subgrades
sublates10315003sub_lates
sublease1038383sublease_
subleased1246123subleased
submerses1348003submerses
subpanel1246073subp_anel
subpanels1344393subp_anels
subparts1246903subp_arts
subraces12313033sub_races
subsales10310123sub_sales
subscales1347343subscales
subsenses1147473subsenses
subshafts1743093subshafts
subspaces1545673subspaces
substages12127353substages
substates111410333substates
subtasks1444493sub_tasks
subthemes1644113subthemes
sucrases10310253su_crases
suitcases1144453suitcases
sulphas1236243sulpha__s
sulphate1346643sulphate_
sulphated1544723sulphated
sulphides1544693sulphides
sulphites1445683sulphites
sulphones1446063sulphones
sunshades1344153sunshades
supposes1238203su_pposes
surbases10310003su_rbases
surceases1157473surceases
surpass938283surp_as_s
surpasses1145533surpasses
surpluses1155433surpluses
surprises1137433surprises
suspenses11106413suspenses
symphyses2244163symphyses
upases84112903_u_p_ases

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 Filter1786911486410.436409841.7
2DLD Change Limit148641616.93621430.4
3Display Results61610.0331848.5
 (SQL Overall)178691617.40524131.1
 
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.