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

177 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
pythons153736(None) 
python1447141python_
cytons111710182cyt_ons
mythos14398462mytho_s
pathos115516692patho_s
patrons93818102patrons
phons105221142p__hons
phytons15319062phyt_ons
pitons85319042pit_ons
pothos114214692potho_s
potions93417422potions
putons83515152put_ons
pylons113011242py_lons
pythoness1743732pythoness
pythonic1847552pythonic
syphons1537502syphons
typhons1537082typhons
actions94218513actions
althorns1146733althorns
aphthous1694873aphthous
archons12311583archons
authors10311853authors
bathos116215633batho_s
batons85519423bat_ons
benthons1337973benthons
bethorns1337323bethorns
betons84919553bet_ons
buttons9310333buttons
cations94524143cations
citrons92913223citrons
cottons9312193cottons
cyton101511463cyt_on_
erythrons1554963erythrons
ethions1038483_ethions
ethnos947053_ethnos
ethos85514193_etho_s
etymons1244153etymons
fathoms1537523fathoms
futons93911513fut_ons
gryphons1743963gryphons
gyrons105511223gy_rons
hons77350783___hons
hyphens1836043hyphens
hysons1237633hy_sons
introns73515023introns
jetons134512613jet_ons
jettons1437273jettons
kations114013663kations
kythes16499133kyth_es
kything18285523kything
lithops12307253lithops
lithos94212553litho_s
lotions74614763lotions
matrons93517633matrons
methods1338883methods
motions94215003motions
mutons84314363mut_ons
muttons949283muttons
mythoi14417133mytho_i
myths135911603myth__s
nations74720563nations
natrons73215663natrons
nitons64614903nit_ons
notions74014483notions
nylons9267973ny_lons
options93810603options
pactions122613503pactions
paeons83915523p_aeons
pantheons1446513pantheons
pardons103817623pardons
parsons93516873parsons
partons94620513partons
patens84820863pat_ens
pathogens1545713pathogens
pathoses13412773pathoses
paths105521383path__s
patins87528783pat_ins
patios85221783patio_s
patois84319363pat_ois
patrols93513513patrols
patron84018043patron_
patroons102710603patroons
pattens95414923pattens
peahens12307573peahens
pechans14810503pechans
pennons939713pennons
peons75327183p__eons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
petrols92913083petrols
petrous92714423petrous
phon95925383p__hon_
phone105621933p__hone
phones114121213p__hones
phono104917023p__hono
phonons123310253phonons
phonos114114793p__honos
phony136715443p__hony
photons123814433photons
phots105418503p__hots
phytins15317893phyt_ins
phytols15276553phyt_ols
phyton143610253phyt_on_
pigeons1039183pigeons
pinions93413603pinions
pinons86019943p_inons
pinyons12299003pinyons
pions75826393p__ions
pistons93016373pistons
piteous9310683piteous
pithing134014053pithing
piths105817543pith__s
pitmans11188743pitmans
piton76121583pit_on_
platoons1038683platoons
pleons84213343p_leons
plutons938343plutons
poisons9310353poisons
pompons1338553pompons
pons65850603p___ons
pontons93315553pontons
pontoons10279313pontoons
poons75430973p__oons
portions10514413portions
potboys1475273potboys
poteens92910883poteens
potheens13266483potheens
pothers123818623pothers
pothole12312173pothole
potholes13312933potholes
pothook1656883pothook
pothooks1746053pothooks
pothouse1348703pothouse
potion84519573potion_
potshots1346283potshots
pottos84615873potto_s
prions84317783p_rions
prisons9313223prisons
protons93118003protons
psychos1765263psycho_s
putdowns1443523putdowns
putlogs1065083putlogs
puton73617913put_on_
pyins105815863py__ins
pylon103614003py_lon_
pyrans11411063py_rans
pyrone112714473py_rone
pyrones123113303py_rones
pyros105718293py_ro_s
pyrrols1235403pyrrols
rations74123433rations
ratoons73815473ratoons
rattons73815323rattons
rhytons13295883rhyt_ons
setons64620173set_ons
siphons1239353siphons
sithens1039383sithens
syphon1436853syphon_
thens85921833__thens
thins85826333__thins
thong95014183__thong
thongs104611193__thongs
thorns95314103__thorns
thous86017263__thous
tons46553053__t_ons
toons55027533__toons
tycoons1235173tycoons
typhon1436673typhon_
typhoons1644563typhoons
typhous1566323typhous
tythes12419703tyth_es
tything14316573tything
withins133511693withins
yahoos12209243_yahoos
yapons114411773_yapons
yupons11398353_yupons

Search took 7 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.1561145455.1
2DLD Change Limit1340271776.54620474.6
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.76526414.0
 
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.