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

164 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
syphon143685(None) 
siphon1138461siphon
syphons1537501syphons
typhon1436671typhon
gryphon1643872gryphon
hyphen1736392hyphen
phon95925382__phon
python1447142python
siphons1239352siphons
skyphoi1963012skyphoi
skyphos1963732skyphos
spoon74719442s_poon
symphony2144502symphony
syph125413272syph__
sypher14317082sypher
syphoned1745732syphoned
syphs13519452syph_s
typhons1537082typhons
typhoon1544652typhoon
alphorn1246393alphorn
apron7318833_apron
archon11311753archon
capon95221873cap_on
chon96627793__chon
ciphony1744973ciphony
cypher16306593cypher
cyton101511463cy_ton
ephod1139123_ephod
ephor10310013_ephor
euphony1545403euphony
gipon84212413gip_on
gryphons1743963gryphons
gyron95314623gy_ron
hon67759383___hon
hyperon1548183hyperon
hypha1637383hyph_a
hyphae1746433hyphae
hyphal1736413hyphal
hyphens1836043hyphens
hypo127516353hyp_o_
hypos1312014743hyp_os
hyson1138693hy_son
jupon14479193jup_on
krypton1643283krypton
lepton82510803lepton
mythoi14417133mythoi
mythos14398463mythos
nephron1246653nephron
nylon82910513ny_lon
nympho1643583nympho_
nymphos1744083nymphos
orphan1137733orphan
peon65635243__peon
phone105621933__phone
phono104917023__phono
phons105221143__phons
phony136715443__phony
phot95534363__phot
pion67235293__pion
poon67341263__poon
psycho1674533psycho_
psychos1765263psychos
pylon103614003py_lon
pythons1537363pythons
salmon84614183salmon
salon55228553s_alon
saloon64418023saloon
saphena1235863saphena
sapor75119253sap_or
saxhorn1744223saxhorn
scion72214993s_cion
scyphi1643173scyph_i
scyphus1743203scyphus
season62714903season
senhor93010813senhor
sepoy10314303sep_oy
sermon8413553sermon
seton55223543s_eton
sexton133610793sexton
shin75634313s__hin
shippon14285803shippon
shod86225063s__hod
shoe75933443s__hoe
shog86025143s__hog
shone83725983s__hone
shoo75929893s__hoo
shoon84022013s_hoon
shop95629843s__hop
shorn85722183s__horn
shot76150263s__hot
show106229193s__how
shown115216483s__hown
shun75122773s__hun
simoon858063simoon
siphonal1345313siphonal
siphoned1446413siphoned
siphonic1547983siphonic
solion6616383solion
solon55026133s_olon
son37761953s___on
soon46240503s__oon
soph97024203soph__
sophs104916023soph_s
sophy136611763soph_y
sopor74016493sop_or
soupcon1144163soupcon
span65234663s_p_an
spawn107811713s_pawn
spean74620513s_pean
sphene113412403s_phene
sphinx1866203s_phinx
sphynx2152613s_phynx
spin66231303s_p_in
spoof105019013s_poof
spook115416043s_pook
spool75219043s_pool
spoons84116023s_poons
spoony114111793s_poony
spoor75016353s_poor
spot65540693s_p_ot
spun66221463s_p_un
spurn74815453s_purn
stepson945673stepson
stolon64112073stolon
sulphone1345983sulphone
summon1037623summon
swoon85014783s_woon
sybo9714743sy_bo_
sylph1347793sylph__
sylphic1745883sylphic
sylphid1645963sylphid
sylphs1435543sylph_s
sylphy1744153sylph_y
sylvan12257363sylvan
sylvin12247303sylvin
symbion1464043symbion
symbol1336083symbol
symphonic2146073symphonic
symptom1644003symptom
syn67024123sy___n
synanon1044743synanon
syncom1336093syncom
synod9610283sy_nod
syntony1344523syntony
syphers15317273syphers
syphoning1845393syphoning
syren85216743sy_ren
syrphian1643453syrphian
syrphid1646103syrphid
sysop1037193sy_sop
tycoon1136023tycoon
typhoid1648133typhoid
typhonic1847173typhonic
typhoons1644563typhoons
typhose1546693typhose
typhous1566323typhous
typhus14395713typhus
typo95418123typ_o_
typos106015813typ_os
upon65817583_up_on
yahoo112911543_yahoo
yapon104613583_yapon
yon67348953_y__on
yupon10469483_yupon

Search took 6 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.390458182.1
2DLD Change Limit1127161645.20321663.7
3Display Results1641640.0463565.2
 (SQL Overall)1786911645.63931688.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.