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

216 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
siphons123935(None) 
siphon1138461siphon_
syphons1537501syphons
ciphony1744972ciphony
gipons9389602gip_ons
phons105221142__phons
shippons15255662shippons
simoons937942simoons
siphonal1345312siphonal
siphoned1446412siphoned
siphonic1547982siphonic
sithens1039382sithens
spoons84116022s_poons
syphon1436852syphon_
typhons1537082typhons
alphorns1345223alphorns
antiphons1447103antiphons
aprons8316993_aprons
archons12311583archons
bicrons113410473bicrons
bighorns1445253bighorns
billons93013363billons
bipods11408593bip_ods
bishops1437033bishops
bisons83914373bi_sons
capons104119503cap_ons
cions75222853ci__ons
ciphers14379993ciphers
ciphonies1646543ciphonies
citrons92913223citrons
diaphone1447103diaphone
diaphones1547443diaphones
diaphony1744123diaphony
diploes101111493diploes
diplont10311693diplont
diplonts1146473diplonts
dipnoans1144103dipnoans
dipsos95310053dipso_s
diurons838823diurons
eikons1038503ei_kons
ephods1238363_ephods
ephors11311403_ephors
epigons1048183epigons
euphony1545403euphony
gibbons1234983gibbons
gibsons1045043gibsons
gipon84212413gip_on_
girons75014373gi_rons
gryphons1743963gryphons
hipbone1445923hipbone
hipbones1546023hipbones
hippos13408433hippo_s
hons77350783___hons
hyphens1836043hyphens
ichors11310423_ichors
icons76516493_i_cons
ikons96311013_i_kons
inions64417003_inions
ions46737853_i__ons
irons55324133_i_rons
isogons8217613isogons
jupons15377803jup_ons
leptons91910433leptons
lichens123510683lichens
lions55923213li__ons
lipins85016883lip_ins
lippens11328533lippens
lithops12307253lithops
lithos94212553litho_s
microns113814783microns
mignons1037863mignons
mikrons13428413mikrons
minions93314623minions
nephrons1346853nephrons
ninons64913773ni_nons
nitons64614903ni_tons
orphans1237773orphans
peons75327183__peons
phon95925383__phon_
phone105621933__phone
phones114121213__phones
phono104917023__phono
phonos114114793__phonos
phony136715443__phony
phots105418503__phots
pigeons1039183pigeons
pinions93413603pinions
pinons86019943pi_nons
pinyons12299003pinyons
pions75826393__pions
pipkins15328183pipkins
pippins10319753pippins
pistons93016373pistons
pitons85319043pi_tons
pons65850603__p_ons
poons75430973__poons
pythons1537363pythons
ribbons1136253ribbons
richens12349733richens
ripens85012173rip_ens
salmons93713263salmons
salons63823693s_alons
saloons74415323saloons
saphena1235863saphena
saphenas1345713saphenas
sapiens9310173sapiens
sapors84118813sap_ors
saxhorns1843833saxhorns
scions82612243s_cions
seasons72614233seasons
senhors103512133senhors
sepoys1138473sep_oys
sermons9311783sermons
setons64620173s_etons
sextons143710413sextons
shins85131043s__hins
shippens15316803shippens
shippon14285803shippon_
shoes85429663s__hoes
shogs95319713s__hogs
shone83725983s__hone
shoos84226363s__hoos
shops104222903s__hops
shots84730853s__hots
shows115324583s__hows
shuns85018143s__huns
sickens134411483sickens
sickos125112033sicko_s
siemens938413siemens
sighers113712183sighers
sighing123311663sighing
sighs95416743sigh__s
sights103818013sigh_ts
siglos7311473siglo_s
signors83410913signors
signs65516323si__gns
silicons10107163silicons
silos56029433si_lo_s
silvans10308333silvans
simians959203simians
simious939803simious
simlins9311843simlins
simony1137903si_mony
simooms1135573simooms
simoon858063simoon_
sinhs86719603sinh__s
sins46755273si___ns
sinuous739063sinuous
sipes76036953sip__es
siphonage1542953siphonage
siphonages1642993siphonages
siphoning1546133siphoning
siping94220633sip_ing
sippers113117753sippers
sippets113310183sippets
sipping123117433sipping
sips65740103sip___s
sirens65318153si_rens
sirloins836723sirloins
siskins1159583siskins
sitcoms1145533sitcoms
sixmos1534813sixmo_s
skyphos1963733skypho_s
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
spigots1037793spigots
spinors939423spinors
spinous9310443spinous
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
symphony2144503symphony
syphers15317273syphers
syphoned1745733syphoned
syphs13519453syph__s
tiglons837343tiglons
tigons74112263ti_gons
tinhorns1145013tinhorns
tiptoes939173tiptoes
tiptops1136073tiptops
typhon1436673typhon_
typhoons1644563typhoons
typhous1566323typhous
virions1039873virions
visions10311023visions
wigeons1136983wigeons
withins133511693withins
xiphoid2045923xiphoid
xiphoids2144193xiphoids
yapons114411773yap_ons
yupons11398353yup_ons
zircons1854963zircons

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.436409841.7
2DLD Change Limit1340272167.23618522.2
3Display Results2162160.0762842.1
 (SQL Overall)1786912167.74823062.9
 
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.