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

191 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
python144714(None) 
pythons1537361pythons
cyton101511462cyt_on
mythoi14417132mythoi
mythos14398462mythos
pathos115516692pathos
patron84018042patron
phon95925382p__hon
phyton143610252phyt_on
piton76121582pit_on
pothos114214692pothos
potion84519572potion
puton73617912put_on
pylon103614002py_lon
pythonic1847552pythonic
syphon1436852syphon
typhon1436672typhon
action84719683action
altho86312603altho_
althorn1047763althorn
archon11311753archon
author939763author
bathos116215633bathos
baton75822423bat_on
benthon1237693benthon
bethorn1238643bethorn
beton76022063bet_on
button8310273button
cation83925503cation
chon96627793__chon
citron83112983citron
cotton8312993cotton
cytons111710183cyt_ons
elytron1045463elytron
erythron1444723erythron
ethion938813_ethion
ethos85514193_ethos
etymon1134693etymon
fathom1437473fathom
futon83113773fut_on
gryphon1643873gryphon
gyron95314623gy_ron
hon67759383___hon
hyphen1736393hyphen
hyson1138693hy_son
intron64215023intron
jeton124815403jet_on
jetton1338033jetton
kation104315683kation
kythe15509673kyth_e
kythed17407313kythed
kythes16499133kythes
kything18285523kything
litho86513783litho_
lithos94212553lithos
lotion65716523lotion
matron83918313matron
method1239023method
motion85217553motion
muton73817003mut_on
mutton8510453mutton
myth126715433myth__
mythic1637273mythic
myths135911603myth_s
mythy16568673myth_y
nation64322803nation
natron64116023natron
niton55418283nit_on
notion64516583notion
nylon82910513ny_lon
option83612713option
ortho8312293ortho_
paction112713963paction
paeon74819493p_aeon
pantheon1346313pantheon
pardon94618733pardon
parson83817903parson
parton84720993parton
paten74827343pat_en
path99134913path__
pathogen1446463pathogen
paths105521383path_s
patin76832853pat_in
patio74426353patio_
patios85221783patios
patrol83213023patrol
patrons93818103patrons
patroon92811973patroon
patten84418193patten
peahen113410133peahen
pechan13511543pechan
pelon74423213p_elon
pennon8310643pennon
peon65635243p__eon
pereon83517453pereon
perron83216623perron
person83517873person
petrol82714063petrol
petto76021043petto_
phone105621933p__hone
phono104917023p__hono
phonon114012033phonon
phons105221143p__hons
phony136715443p__hony
phot95534363p__hot
photon1111514833photon
phylon14318033phylon
phytin14459013phyt_in
phytol14366563phyt_ol
phytons15319063phyt_ons
pigeon949413pigeon
pinion83815893pinion
pinon76024533p_inon
pinyon11459763pinyon
pion67235293p__ion
piston83515923piston
pith95432693pith__
pithed124615613pithed
pithing134014053pithing
piths105817543pith_s
pithy135614463pith_y
pitman102412123pitman
pitmen102510793pitmen
pitons85319043pit_ons
platoon938953platoon
pleon74216383p_leon
pluton838853pluton
poison8312223poison
pompon1238943pompon
ponton83217643ponton
pontoon93010703pontoon
poon67341263p__oon
portion9615493portion
potboy1397813potboy
poteen83514263poteen
potheen12257893potheen
pother113818853pother
pothole12312173pothole
pothook1656883pothook
potions93417423potions
potman102813573potman
potmen102713093potmen
potshot1249733potshot
potto75320943potto_
pottos84615873pottos
prion75119993p_rion
prison8514023prison
proton84318893proton
prythee1545383prythee
psycho1674533psycho_
psychos1765263psychos
putdown1343883putdown
putlog965553putlog
putons83515153put_ons
putto75617663putto_
pyin96823233py__in
pylons113011243py_lons
pyran10514473py_ran
pyro96019393py_ro_
pyrone112714473py_rone
pyros105718293py_ros
pyrrol1136273pyrrol
pythoness1743733pythoness
ration64226013ration
ratoon64417373ratoon
ratton64116123ratton
rhyton12356113rhyt_on
seton55223543set_on
siphon1138463siphon
syphons1537503syphons
than76128773__than
then78429693__then
thin76732393__thin
tho67433963__tho_
thong95014183__thong
thorn85318703__thorn
thou76722213__thou
ton310265103__t_on
toon47740633__toon
tycoon1136023tycoon
typhons1537083typhons
typhoon1544653typhoon
tythe115210453tyth_e
tythed13457503tythed
tythes12419703tythes
tything14316573tything
within123611383within
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.1231452772.4
2DLD Change Limit1127161915.54620323.8
3Display Results1911910.0633031.7
 (SQL Overall)1786911915.73231174.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.