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

51 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
typhuses164376(None) 
cypruses1534312cypruses
kyphoses2045282kyphoses
taphouses1446552taphouses
typhose1546692typhose_
typhus14395712typhu__s
apheses12610703_apheses
bypasses1533833bypasses
byssuses1342273byssuses
cypreses1535143cypreses
emphases1568353emphases
enthuses1138253enthuses
espouses1037303espouses
gyplures14102153gyplures
hypnoses1646633hypnoses
kyphosis2045173kyphosis
lupuses936273lup_uses
opuses84012243_op_uses
pauses84621473__pauses
pepluses1287013pepluses
phases114618403__phases
physes14399783__physes
pluses83618073__pluses
puses75532203__p_uses
rhuses94911793__rhuses
spouses92912813_spouses
styluses11204773sty_luses
stypsises1443423stypsises
symphyses2244163symphyses
taluses7311213t_aluses
tapholes1339623tapholes
taphouse1346333taphouse_
tapises92914013tap_ises
teahouses1246513teahouses
theses96517973t__heses
thymuses1643073thymuses
tonuses73612193t_onuses
tophes115218423toph__es
tophus115210363tophu__s
touses64229673t__ouses
typecases1643853typecases
types105721063typ___es
typeset1267743typ_eset
typesets1343213typ_esets
typhoids1745493typhoids
typhons1537083typh_ons
typhoons1644563typhoons
typhous1566323typh_ous
typifies1644963typifies
typists1236173typ_ists
tythes12419703tyth__es

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 Filter1786911461620.186960704.3
2DLD Change Limit146162518.17317883.5
3Display Results51510.0133923.1
 (SQL Overall)178691518.37221343.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.