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

179 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
typhus1439571(None) 
tophus115210361tophus
typhous1566321typhous
cyprus1335362cyprus
scyphus1743202scyphus
syphs13519452syph_s
thus76721472t__hus
tophes115218422tophes
tophs105220052toph_s
types105721062typ_es
typhon1436672typhon
typhons1537082typhons
typhose1546692typhose
typhuses1643762typhuses
typos106015812typ_os
typps12549302typ_ps
tythes12419702tythes
alphas1139513alphas
aphis105917133_aphis
ayahs116813523ayah_s
bupkus14385683bupkus
bypass1345043bypass
byssus1133763byssus
caphs124515373caph_s
clypeus1433243clypeus
coypous14248813coypous
coypus13389303coyp_us
cymous1388403cymous
cypher16306593cypher
cyphers17316753cyphers
cypres1338523cypres
ephas10311543_ephas
fichus14388113fichus
glyphs1534303glyph_s
gyps105115023gyp__s
gypsum1442853gypsum
gypsums1541923gypsums
gyrus95310803gy_rus
hypers144811913hypers
hypes135818673hyp_es
hypha1637383hyph_a
hyphae1746433hyphae
hyphal1736413hyphal
hyphen1736393hyphen
hyphens1836043hyphens
hypos1312014743hyp_os
hyps125418413hyp__s
jehus15488573_jehus
kaphs144911503kaph_s
kophs145010933koph_s
kythes16499133kythes
lapsus8437273lapsus
lupous849433lupous
lupus74512523lup_us
lyches144213613lyches
lymphs1635053lymph_s
mythos14398473mythos
myths135911603myth_s
nymphos1744083nymphos
nymphs1633503nymph_s
opus66420593_op_us
ouphes113614633ouphes
ouphs104311273ouph_s
pappus9408373pappus
peplus10138343peplus
phis95724903__phis
phut96925973__phut
phuts104613503__phuts
plus66324833__plus
prahus11458243prahus
pupus94614043pup_us
pus55547843__p_us
qophs19507813qoph_s
raphes115117453raphes
raphis114014323raphis
rhus75114053__rhus
sadhus10298463sadhus
skyphos1963733skyphos
sophs104916023soph_s
staphs114411033staph_s
stylus9397463sty_lus
stypsis1245243stypsis
sylphs1435543sylph_s
syph125413273syph__
sypher14317083sypher
syphers15317273syphers
syphon1436853syphon
syphons1537503syphons
tabus74820923t_abus
taches114224173taches
tachs105820933tach_s
tahrs85412333t_ahrs
talus55423263t_alus
tapas74627713tap_as
tapers84025813tapers
tapes75838603tap_es
taphouse1346333taphouse
tapirs84113173tapirs
tapis75028863tap_is
taps66050673tap__s
tarsus6310513tarsus
taus46342733t__aus
taxus125512483t_axus
techs106915833tech_s
tendus75111183tendus
tepals85415043tepals
tepas76521683tep_as
tepees84215243tepees
tephra1136483tephra
tephras1236283tephras
tepoys1137543tepoys
teths85418513teth_s
this76027383t__his
thous86017263t_hous
thud85613913t__hud
thuds95110133t__huds
thug86415483t__hug
thugs95611993t__hugs
thymus14324743thymus
thyrsus1342693thyrsus
tights104015853tights
tipis76019923tip_is
tips66436763tip__s
tithes94720213tithes
tofus86415423t_ofus
tolus55024483t_olus
tonus56324303t_onus
topees85519703topees
topers85025323topers
topes76941763top_es
topful1136543topful
toph96326873toph__
tophe106718973toph_e
tophi105215303toph_i
topics104714583topics
topis76025833top_is
topos75726393top_os
tops66248123top__s
torous64319033torous
torus54329763t_orus
toshes94520103toshes
tragus749233tragus
tuchun1145443tuchun
tuchuns1233983tuchuns
tupiks1235493tupiks
tups65628763tup__s
tushes94319473tushes
tutus55214813t_utus
tyees86019453ty_ees
tyers86220053ty_ers
tyes76433373ty__es
tykes125817063ty_kes
tympans14236813tympans
tynes85920303ty_nes
typal105311153typ_al
type96223743typ__e
typed115815453typ_ed
typey135511883typ_ey
typhoid1648133typhoid
typhoids1745493typhoids
typhoon1544653typhoon
typhoons1644563typhoons
typic124511963typ_ic
typier1137333typier
typiest1238203typiest
typify1734523typify
typing124110583typing
typist1139823typist
typists1236173typists
typo95418123typ__o
typp115812783typ__p
typy126013043typ__y
tyres84725233ty_res
tyros85118593ty_ros
tythe115210453tyth_e
tythed13457503tythed
wyches17387913wyches
xystus16354423xystus
yous76230653_y_ous

Search took 5 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161794.41025559.2
3Display Results1791790.0434162.8
 (SQL Overall)1786911794.82637026.7
 
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.