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 “typhons” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
typhons153708(None) 
syphons1537501syphons
typhon1436671typhon_
typhoons1644561typhoons
typhous1566321typhous
gryphons1743962gryphons
hyphens1836042hyphens
phons105221142__phons
pythons1537362pythons
siphons1239352siphons
syphon1436852syphon_
tycoons1235172tycoons
typhoid1648132typhoid
typhoids1745492typhoids
typhonic1847172typhonic
typhoon1544652typhoon
typhose1546692typhose
typhus14395712typh_us
typos106015812typ_o_s
alphorns1345223alphorns
antiphons1447103antiphons
aprons8316993_aprons
archons12311583archons
capons104119503cap_ons
ciphony1744973ciphony
cyphers17316753cyphers
cytons111710183cy_tons
ephods1238363_ephods
ephors11311403_ephors
ethephons1743373ethephons
etymons1244153ety_mons
euphony1545403euphony
gipons9389603gip_ons
gryphon1643873gryphon_
gyrons105511223gy_rons
hons77350783___hons
hyperons1649203hyperons
hyphen1736393hyphen_
hypos1312014743hyp_o_s
hysons1237633hy_sons
jupons15377803jup_ons
kryptons1743223kryptons
kyphoses2045283kyphoses
kyphosis2045173kyphosis
leptons91910433leptons
mythos14398473mytho_s
nephrons1346853nephrons
nylons9267973ny_lons
nymphos1744083nympho_s
orphans1237773orphans
peons75327183__peons
phon95925383__phon_
phone105621933__phone
phones114121213__phones
phono104917023__phono
phonos114114793__phonos
phony136715443__phony
phots105418503__phots
pions75826393__pions
pons65850603__p_ons
poons75430973__poons
pylons113011243py_lons
python1447143python_
siphon1138463siphon_
skyphos1963733skypho_s
spoons84116023_spoons
stepsons1045663stepsons
symphony2144503symphony
syphers15317273syphers
syphoned1745733syphoned
syphs13519453syph__s
tachyons1644623tachyons
talions7314113talions
talons64019443t_alons
tampions12358123tampions
tampons112711563tampons
taphole1239773taphole
tapholes1339623tapholes
taphouse1346333taphouse
tarpons92612213tarpons
tauons63412673t_auons
taxons134211503t_axons
technos1236183technos
teflons1036543teflons
telsons739223telsons
tendons8311473tendons
tenons62916603t_enons
tephras1236283tephras
tepoys1137543tep_oys
testons7313563testons
thens85921833t__hens
thins85826333t__hins
thong95014183t__hong
thongs104611193t__hongs
thorns95314103t__horns
thorons104511913thorons
thous86017263t__hous
tiglons837343tiglons
tigons74112263t_igons
tinhorns1145013tinhorns
tiptoes939173tiptoes
tiptops1136073tiptops
tompions12267003tompions
tons46553053t___ons
toons55027533t__oons
tophes115218423toph_es
tophs105220053toph__s
tophus115210363toph_us
topos75726393top_o_s
torchons1337503torchons
toyons95512133t_oyons
toyshops1644433toyshops
trigons84312093trigons
tritons73814883tritons
trogons83410723trogons
trypsins1344903trypsins
tuchuns1233983tuchuns
turions7311573turions
turnons737863turnons
tycoon1136023tycoon_
tympans14236813tympans
types105721063typ__es
typhuses1643763typhuses
typing124110583typ_ing
typists1236173typists
typo95418123typ_o__
typps12549303typ__ps
tyros85118593ty_ro_s
tythes12419703tyth_es
tything14316573tything
yahoos12209243_yahoos
yapons114411773_yapons
yupons11398353_yupons

Search took 7 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.423422437.4
2DLD Change Limit1340271336.40620922.1
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.87525991.4
 
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.