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

155 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
syphons153750(None) 
siphons1239351siphons
syphon1436851syphon_
typhons1537081typhons
gryphons1743962gryphons
hyphens1836042hyphens
phons105221142__phons
pythons1537362pythons
siphon1138462siphon_
skyphos1963732skypho_s
spoons84116022s_poons
symphony2144502symphony
syphers15317272syphers
syphoned1745732syphoned
syphs13519452syph__s
typhon1436672typhon_
typhoons1644562typhoons
typhous1566322typhous
alphorns1345223alphorns
aprons8316993_aprons
archons12311583archons
capons104119503cap_ons
ciphony1744973ciphony
cyphers17316753cyphers
cytons111710183cy_tons
ephods1238363_ephods
ephors11311403_ephors
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
psychos1765263psycho_s
pylons113011243py_lons
python1447143python_
salmons93713263salmons
salons63823693s_alons
saloons74415323saloons
saphena1235863saphena
saphenas1345713saphenas
sapiens9310173sapiens
sapors84118813sap_ors
saxhorns1843833saxhorns
scions82612243s_cions
scyphus1743203scyph_us
seasons72614233seasons
senhors103512133senhors
sepoys1138473sep_oys
sermons9311783sermons
setons64620173s_etons
sextons143710413sextons
shins85131043s__hins
shippons15255663shippons
shoes85429663s__hoes
shogs95319713s__hogs
shone83725983s__hone
shoos84226363s__hoos
shops104222903s__hops
shots84730853s__hots
shows115324583s__hows
shuns85018143s__huns
simoons937943simoons
siphonal1345313siphonal
siphoned1446413siphoned
siphonic1547983siphonic
sithens1039383sithens
skyphoi1963013skypho_i
solions7513753solions
solons65120023s_olons
sons46049553s___ons
sophies12314623sophies
sophs104916023soph__s
sopors85215203sop_ors
soupcons1244373soupcons
spans74528733s_p_ans
spawns11577923s_pawns
speans85417143s_peans
sphene113412403s_phene
sphenes123013163s_phenes
sphinx1866203s_phinx
sphynx2152613s_phynx
spins75327983s_p_ins
spoofs114011813s_poofs
spooks124312933s_pooks
spools85115913s_pools
spoon74719443s_poon_
spoony114111793s_poony
spoors84014033s_poors
spots74424113s_p_ots
spurns84811383s_purns
stepsons1045663stepsons
stolons73410243stolons
sulphone1345983sulphone
sulphones1446063sulphones
summons1158003summons
swoons94511143s_woons
syboes1139343sy_boes
sylphids1743953sylphids
sylphs1435543sylph__s
sylvans13235893sylvans
sylvins13246243sylvins
symbions1563933symbions
symbols1435523symbols
symphonic2146073symphonic
symphonies2046143symphonies
symphonist20135923symphonist
symptoms1743763symptoms
synanons1144633synanons
syncoms1435943syncoms
synods1077953sy_nods
syntony1344523syntony
syph125413273syph___
sypher14317083syph_er
syphilis1645823syphilis
syphoning1845393syphoning
syrens94911993sy_rens
syrphians1742763syrphians
syrphids1744243syrphids
sysops1136013sy_sops
tycoons1235173tycoons
typhoid1648133typhoid
typhoids1745493typhoids
typhonic1847173typhonic
typhoon1544653typhoon
typhose1546693typhose
typhus14395713typh_us
typos106015813typ_o_s
yahoos12209243_yahoos
yapons114411773_yapons
yupons11398353_yupons

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271557.23618522.2
3Display Results1551550.0602583.3
 (SQL Overall)1786911557.70223200.6
 
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.