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

77 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
typhous156632(None) 
typhons1537081typhons
typhus14395711typh_us
syphons1537502syphons
taphouse1346332taphouse
thous86017252t__hous
tophus115210362toph_us
typhoid1648122typhoid
typhoids1745492typhoids
typhon1436672typho_n
typhoon1544652typhoon
typhoons1644562typhoons
typhose1546692typhose
typos106015812typ_o_s
cachous14312563cachous
copious11311963copious
coypous14248813coyp_ous
cuprous1149743cuprous
cymous1388403cy_mous
cyphers17316753cyphers
cyprus1335363cyp_rus
ephods1238363_ephods
ephors11311403_ephors
gryphons1743963gryphons
gypseous1462553gypseous
hydrous14197883hydrous
hyphens1836043hyphens
hypos1312014743hyp_o_s
impious1137063impious
kyphoses2045283kyphoses
kyphosis2045173kyphosis
leprous938843leprous
lupous849433lup_ous
mythos14398463mytho_s
nymphos1744083nympho_s
pappous1057463pappous
phons105221143__phons
phots105418493__phots
pious74621273__pious
pythons1537363pythons
scyphus1743203scyph_us
siphons1239343siphons
skyphos1963733skypho_s
syphers15317273syphers
syphon1436853sypho_n
syphs13519453syph__s
talcous939483talcous
taphole1239773taphole
tapholes1339623tapholes
taphouses1446553taphouses
teahouse1146073teahouse
tedious838443tedious
tenuous738473tenuous
tephras1236283tephras
tepoys1137543tep_oys
thou76722213t__hou_
thus76721473t__h_us
timeous938403timeous
tiptoes939173tiptoes
tiptops1136073tiptops
tophes115218423toph_es
tophs105220053toph__s
topos75726393top_o_s
torous64319023t_orous
toyshops1644433toyshops
trappous1246013trappous
tycoons1235173tycoons
types105721063typ__es
typhonic1847173typhonic
typhuses1643763typhuses
typists1236173typists
typo95418123typ_o__
typps12549303typ__ps
tyros85118593ty_ro_s
tythes12419703tyth_es
yahoos12209243_yahoos
yous76230653_y__ous

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027778.39015974.6
3Display Results77770.0302566.7
 (SQL Overall)178691778.57620836.2
 
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.