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

65 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
subphase155560(None) 
subphases1645761subphases
subbase1139332sub_base
subchaser1644322subchaser
sublease1038382sublease
sulphas1236242sulphas_
sulphate1346642sulphate
anaphase1345463anaphase
diphase1387273_diphase
inphase1245393_inphase
phase104617213___phase
prophase15410243prophase
purchase1545293purchase
scyphate1843273scyphate
slipcase1263923slipcase
subahs114512393subah_s_
subas74724083sub__as_
subbases1239073sub_bases
subbass1138043sub_bass
subcaste1287863sub_caste
subcause1265833subcause
subchasers1743293subchasers
subclass1246633subclass
subclause1353853subclause
suberise10813933suberise
suberose10109693suberose
subframe1546333subframe
subgrade1246053subgrade
sublate9315363sub_late
subleased1246123subleased
subleases1148653subleases
submerse1237633submerse
subovate1347333subovate
subpanel1246083subp_anel
subpar1048673subp_a_r
subpart11311133subp_art
subpenas1246913subpenas_
subphyla1842123subphyla
subrace11313003sub_race
subsale9310553sub_sale
subscale1247613subscale
subsense1046963subsense
subshaft1645183subshaft
subspace1445683subspace
substage11117183substage
substate101711093substate
subtask1335723sub_task
subtheme1544333subtheme
subulate10312753subulate
sucrase9310343su_crase
suitcase1043893suitcase
sulpha1135403sulpha__
sulphated1544723sulphated
sulphates1466173sulphates
sulphide1444623sulphide
sulphite1346003sulphite
sulphone1345983sulphone
sunshade1244353sunshade
suppose1137973su_ppose
surbase939793su_rbase
surcease1086883surcease
surpass938283surp_ass
surprise1037673surprise
suspense10135743suspense
triphase1346193triphase

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 Filter1786911461620.423422437.4
2DLD Change Limit146162657.34319904.9
3Display Results65650.0331969.7
 (SQL Overall)178691657.79922912.0
 
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.