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

234 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
siphon113846(None) 
siphons1239351siphons
syphon1436851syphon
ciphony1744972ciphony
gipon84212412gip_on
phon95925382__phon
shippon14285802shippon
simoon858062simoon
siphonal1345312siphonal
siphoned1446412siphoned
siphonic1547982siphonic
spoon74719442s_poon
syphons1537502syphons
typhon1436672typhon
alphorn1246393alphorn
antiphon1346773antiphon
apron7318833_apron
archon11311753archon
bicron103710773bicron
bighorn1346063bighorn
billon83713833billon
bipod104410823bip_od
bishop1336943bishop
bison75716983bi_son
capon95221873cap_on
chon96627793__chon
cion613330913ci__on
cipher133710263cipher
citron83112983citron
diaphone1447103diaphone
diaphony1744123diaphony
diploe9810153diploe
diplont10311693diplont
dipnoan1044653dipnoan
dipso85111553dipso_
dipsos95310053dipsos
diuron738573diuron
eikon939463ei_kon
ephod1139123_ephod
ephor10310013_ephor
epigon937963epigon
euphony1545403euphony
gibbon1135323gibbon
gibson935123gibson
gipons9389603gip_ons
giron66118993gi_ron
gryphon1643873gryphon
hipbone1445923hipbone
hippo12369063hippo_
hippos13408433hippos
hipshot15106643hipshot
hon67759383___hon
hyphen1736393hyphen
ichor1039483_ichor
icon66922043_i_con
ikon85814953_i_kon
inion54620183_inion
ion36051023_i__on
iron46728463_i_ron
isogon7227543isogon
jupon14479193jup_on
kippen14299013kippen
lepton82510803lepton
lichen114012743lichen
lion46334443li__on
lipin75518893lip_in
lippen103911403lippen
litho86513783litho_
lithos94212553lithos
micron103714283micron
mignon937953mignon
mikron12318503mikron
minion83416243minion
nephron1246653nephron
ninon55517383ni_non
niton55418283ni_ton
orphan1137733orphan
peon65635243__peon
phone105621933__phone
phono104917023__phono
phons105221143__phons
phony136715443__phony
phot95534363__phot
pigeon949413pigeon
pinion83815893pinion
pinon76024533pi_non
pinyon11459763pinyon
pion67235293__pion
pipkin14248603pipkin
pippin92810303pippin
piston83515923piston
piton76121583pi_ton
poon67341263__poon
python1447143python
ribbon1036533ribbon
richen113812513richen
ripen75619263rip_en
salmon84614183salmon
salon55228553s_alon
saloon64418023saloon
saphena1235863saphena
sapor75119253sap_or
saxhorn1744223saxhorn
scion72214993s_cion
season62714903season
senhor93010813senhor
sepoy10314303sep_oy
sermon8413553sermon
seton55223543s_eton
sexton133610793sexton
shin75634313s__hin
shipman14247133shipman
shipmen14317283shipmen
shippen14298863shippen
shippons15255663shippons
shod86225063s__hod
shoe75933443s__hoe
shog86025143s__hog
shone83725983s__hone
shoo75929893s__hoo
shoon84022013s_hoon
shop95629843s__hop
shorn85722183s__horn
shot76150263s__hot
show106229193s__how
shown115216483s__hown
shun75122773s__hun
siccan1037593siccan
sicken124615253sicken
sicko115315393sicko_
sickos125112033sickos
sidh86222993sidh__
sidhe95315103sidh_e
sigh85625893sigh__
sighed113712053sighed
sigher103813703sigher
sighing123311663sighing
sighs95416743sigh_s
sight94629293sigh_t
sights103818013sights
sigloi737743sigloi
siglos7311473siglos
sign55523053si__gn
signor73510353signor
silicon9117533silicon
silken104410853silken
silo46037913si_lo_
silos56029433si_los
silvan92810153silvan
simian8811163simian
simlin8311733simlin
simony1137903si_mony
simoom1037503simoom
simoons937943simoons
sin36265893si___n
sinh76238043sinh__
sinhs86719603sinh_s
sip57656013sip___
sipe67341043sip__e
siped84927683sip_ed
sipes76036953sip_es
siphonage1542953siphonage
siphoning1546133siphoning
siping94220633siping
sipped113720633sipped
sipper103920993sipper
sippet103519393sippet
sipping123117433sipping
sips65740103sip__s
siren54525823si_ren
sirloin747593sirloin
siskin1079783siskin
sitcom1036903sitcom
sith75435153sith__
sithens1039383sithens
sitten64113823sitten
sixmo1448303sixmo_
sixmos1534813sixmos
skyphoi1963013skyphoi
skyphos1963733skyphos
slipshod1442433slipshod
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
spigot9312603spigot
spin66231303s_p_in
spinor839943spinor
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
symphony2144503symphony
syph125413273syph__
sypher14317083sypher
syphoned1745733syphoned
syphs13519453syph_s
tiglon737923tiglon
tigon63914443ti_gon
tinhorn1046033tinhorn
tiptoe838283tiptoe
tiptop1036103tiptop
typhons1537083typhons
typhoon1544653typhoon
upon65817583_up_on
virion9310683virion
vision9311313vision
wigeon1037223wigeon
within123611383within
xiphoid2045923xiphoid
yapon104613583yap_on
yupon10469483yup_on
zircon1754953zircon

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.376475242.0
2DLD Change Limit1127162345.18621734.7
3Display Results2342340.0633714.3
 (SQL Overall)1786912345.62531767.3
 
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.