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

297 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
telsons73921(None) 
kelsons1137321kelsons
nelsons738001nelsons
telson6310291telson_
belons84119412bel_ons
bolsons969482bolsons
felons93615762fel_ons
keelsons1244092keelsons
kelson1038152kelson_
lessons73811012lessons
melons84117712mel_ons
meltons9410922meltons
mesons83215842me_sons
nelson638422nelson_
persons93717012persons
reasons72514942reasons
seasons72614232seasons
selsyns1092942selsyns
stemsons1045002stemsons
stepsons1045662stepsons
stetsons845622stetsons
talions7314102talions
talons64019432tal_ons
teflons1036542teflons
telcos8710682telco_s
telos55424522tel_o_s
telsonic1045992telsonic
tendons8311472tendons
tenons62916602te_nons
tensions8310222tensions
tensors72712372tensors
testons7313552testons
treasons848682treasons
weasons102310582weasons
aeons57624653ae__ons
arsons63917213_arsons
azlons154110423azl_ons
ballons93916963ballons
beacons11410733beacons
beckons15279143beckons
bellows124313303bellows
belon73924113bel_on_
belong93411043bel_ong
belongs10408223bel_ongs
belows114614183bel_ows
benisons1037043benisons
besoms105712733be_soms
besots86415453be_sots
betons84919553be_tons
billons93013363billons
bisons83914373_bisons
bolson8410683bolson_
bosons85016653_bosons
celadons1137003celadons
cellos84517803cello_s
celoms10412123cel_oms
censors93611833censors
cessions1039853cessions
clons75228133_cl_ons
colons86028683col_ons
daltons8310403daltons
damsons1038013damsons
deacons10310393deacons
delusions1037053delusions
demons94917723de_mons
devons104512253de_vons
dobsons1036203dobsons
ebons74316093_e_bons
eikons1038503_eikons
elains64919853_elains
elans55527753_el_ans
elbows1196713_elbows
elevons1067573_elevons
elfins94810943_elfins
elisions82210423_elisions
eloins65419383_eloins
elusions82610083_elusions
eons46638713_e__ons
eosins64419163_eosins
essoins737603_essoins
etalons739073etalons
ethions1038483ethions
etymons1244153etymons
exons125813343_e_xons
falcons1239123falcons
felloes104114383felloes
fellows134212433fellows
felon84619293fel_on_
felony123710323fel_ony
felstone1146863felstone
felstones1246963felstones
foisons1047613foisons
gallons83015953gallons
gessoes838293gessoes
gibsons1045043gibsons
gluons738503_gluons
godsons966663godsons
grisons838993grisons
halons95720713hal_ons
helicons1337613helicons
helios94816633helio_s
hellions11310023hellions
helloes103717463helloes
hellos95321683hello_s
helos84928063hel_o_s
helots95217703hel_ots
herons94820543he_rons
hysons1237633_hysons
jellos134714283jello_s
jetons134512613je_tons
jetsoms16124723jetsoms
jettons1437273jettons
keelson1153993keelson_
kelvins14106563kelvins
legions84611783legions
lemons84415053le_mons
leptons91910423leptons
lesions73813863lesions
lessens7409383lessens
lesson64412043lesson_
lessors73610523lessors
leukons1135753leukons
lions55923213__lions
loons55731723__loons
malisons1048773malisons
masons83916513_masons
mellows123812233mellows
melon73922083mel_on_
melton8311553melton_
merlons93311273merlons
meson74118313me_son_
messans92710463messans
nektons1136393nektons
neocons936913neocons
neons55818683ne__ons
neurons7410443neurons
neustons836833neustons
newtons1036813newtons
nylons9267973nyl_ons
orisons7310563orisons
orlons6411013orl_ons
parsons93516873parsons
pelon74423213pel_on_
pelotons1038913pelotons
pennons939713pennons
pensions10311693pensions
peons75327183pe__ons
pepsins11310433pepsins
pereons92815003pereons
perrons93115483perrons
person83517873person_
persona92812453persona
personas102511883personas
pesos77221623pe_so_s
pleons84213343_pleons
poisons9310353poisons
prisons9313223prisons
pulsions1037713pulsions
pylons113011243pyl_ons
ramsons939563ramsons
reason62616333reason_
reckons13269653reckons
recons84922993re_cons
redons75222183re_dons
regions83613473regions
reloans7313133reloans
relooks114010723relooks
resins64528773re_sins
resods74116303re_sods
resows93915353re_sows
salmons93713263salmons
salons63823693sal_ons
saloons74415313saloons
season62714903season_
seisins73614393seisins
seisors73212833seisors
selsyn983843selsyn_
sensors73514633sensors
sermons9311783sermons
sessions839723sessions
setons64620173se_tons
sextons143710413sextons
solions7513753solions
solons65120023sol_ons
sons46049553___sons
stemson945163stemson_
stepson945673stepson_
sternsons944663sternsons
stetson745783stetson_
stolons73410243stol_ons
talcous939483talcous
talion6317713talion_
tallols73311363tallols
tallows103313743tallows
talon55824113tal_on_
tampons112711553tampons
tarpons92612203tarpons
tatsois748373tatsois
tauons63412673t_auons
taxons134211503t_axons
teapots939053teapots
teapoys1235963teapoys
teasels74311313teasels
teasers75317243teasers
teases65426273teas_es
teashops1345733teashops
teasing83918513teasing
teaspoons1143843teaspoons
technos1236183technos
tedious838443tedious
teens56227483te__ens
teflon937453teflon_
telamon936523telamon_
telamones1146213telamones
telco7511873telco__
telecoms1246473telecoms
teledus835093teledus
telegas837443telegas
telegony1244223telegony
teleost7410523teleost
teleosts846423teleosts
telerans859473telerans
teles54536003tel__es
teleses7313123teleses
teleshops1444773teleshops
telesis7310793telesis
telethons1246013telethons
telexes1438343telexes
telfers10299073telfers
telford1145153telford
telfords1244363telfords
tellers73717593tellers
tellies73820503tellies
telling83321083telling
tells55828943tel__ls
tellys9348843tel_lys
telnets738373telnets
teloi54217383tel_o_i
telome8311923tel_ome
telomes9310533telomes
tels46841693tel___s
tempos103812293tempo_s
tendon7312033tendon_
tenon53320513te_non_
tenors63217753te_nors
tenpins9410073tenpins
tens45647413te___ns
tenses64722553tens_es
tensing84616653tensing
tension7311803tension_
tensor63812673tenso_r
tenuous738483tenuous
teopans939203teopans
tepoys1137543te_poys
termors94712773termors
ternions838813ternions
terns55226873te__rns
terrors73112213terrors
teslas64212173te_slas
testes65125823te_stes
testis64916713te_stis
teston6313303teston_
testoons837303testoons
tests56530193te_s_ts
thorons104511913thorons
tiglons837343tiglons
tigons74112263t_igons
tocsins939963tocsins
tolans64319273tol_ans
toluols735823toluols
tons46553053t___ons
toons55027533t__oons
torsions839183torsions
torsos64815733torso_s
toyons95512133t_oyons
treason748763treason_
trigons84312093trigons
tritons73814883tritons
trogons83410723trogons
turions7311573turions
turnons737863turnons
tussors7388773tussors
tycoons1235173tycoons
tylosins1145723tylosins
typhons1537083typhons
unisons748423unisons
venisons1136133venisons
versions11310353versions
versos93812803verso_s
weakons14287803weakons
weapons12278603weapons
weason93210823weason_
weldors11238003weldors
welkins1437173welkins
welshes13379093welshes
xenons132710483xe_nons
yellows13329603yellows

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.1531167915.0
2DLD Change Limit1340272975.86022871.5
3Display Results2972970.1102700.0
 (SQL Overall)1786912976.12329183.6
 
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.