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

279 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
kelson103815(None) 
keelson1153991keelson
kelsons1137321kelsons
nelson638421nelson
telson6310291telson
belon73924112bel_on
bolson8410682bolson
felon84619292fel_on
keelsons1244092keelsons
kelvin13117322kelvin
lesson64412042lesson
melon73922082mel_on
melton8311552melton
meson74118312me_son
nelsons738002nelsons
pelon74423212pel_on
person83517872person
reason62616332reason
season62714902season
selsyn983842selsyn
telsons739222telsons
weason93210822weason
aeon45634613ae__on
also46423443_also_
arson55118833_arson
azlon144312873azl_on
ballon84117493ballon
beacon10511373beacon
beckon14309383beckon
bellow114213353bellow
belong93411043bel_ong
belons84119413bel_ons
below104617193bel_ow
bels66142493bels__
benison937123benison
besom95716973be_som
besot76429713be_sot
beton76022063be_ton
billon83713833billon
bison75716983_bison
bolsons969483bolsons
boson76019733_boson
celadon1036913celadon
cello74919583cello_
cellos84517803cellos
celom9515693cel_om
cels65534973cels__
censor84011293censor
cession939813cession
clon66232483_cl_on
colon78630193col_on
dalton7311273dalton
damson938063damson
deacon9510423deacon
dels56745473dels__
delusion937433delusion
demon86520313de_mon
devon95113683de_von
dobson936593dobson
ebon66821103_e_bon
eels46536743eels__
eikon939463_eikon
elain55324703_elain
elan46734243_el_an
elbow10117703_elbow
elevon977953_elevon
elfin84312463_elfin
elision72311103_elision
eloin55923203_eloin
els37645723_els__
else45923083_els_e
elusion72310953_elusion
eon36052083_e__on
eosin55220923_eosin
essoin638193_essoin
exon117116803_e_xon
falcon11310293falcon
felloe93513923felloe
fellow123712743fellow
felons93615763fel_ons
felony123710323fel_ony
felsic1147053felsic
felstone1146863felstone
foison948933foison
gallon73715813gallon
gels56836103gels__
gesso649603gesso_
gibson935123gibson
gluon6311223_gluon
godson857383godson
grison7310103grison
halon86124863hal_on
helicon1237643helicon
helio85321193helio_
helios94816633helios
hellion10311133hellion
hello86522983hello_
hellos95321683hellos
helo75332853hel_o_
helos84928063hel_os
helot85332683hel_ot
hereon93914363hereon
heron85025503he_ron
hyson1138693_hyson
jello126716273jello_
jellos134714283jellos
jeon116821443je__on
jeton124815403je_ton
jetsom15126143jetsom
jetton1338033jetton
kalian10312163kalian
kalong1177703kal_ong
kamsin1238323kamsin
kaon87521023k__aon
kation104315683kation
keas86337093keas__
kebob135110923ke_bob
keels94622413keels__
keen84830413ke__en
keeshond1643183keeshond
kefs115922743kefs__
kegs95824023kegs__
kelep116014563kel_ep
keleps12478813keleps
kelim11912553kel_im
kelims1278913kelims
kelly124617023kel_ly
keloid11812623keloid
kelp105322803kel__p
kelped13449553kelped
kelpie12308613kelpie
kelping14319193kelping
kelps115116423kel_ps
kelpy145110683kel_py
kelt85343193kel__t
kelter103214383kelter
kelts95222633kel_ts
kelvins14106563kelvins
ken76343983ke___n
kendo105113223kendo_
kendos114510663kendos
keno87926433ke_no_
kenos95220623ke_nos
kens85435233kens__
keppen14346573keppen
keps106027303keps__
kern85326213ke__rn
kersey1336793kersey
keto86223453ke_to_
ketol95414003ke_tol
ketone105014533ke_tone
ketose105711813ketose
keys116322163keys__
keyset13411533keyset
keystone1545333keystone
kiln85620983kil__n
kilo86028673kil_o_
kilos95021473kil_os
kiloton1196313kiloton
klaxon1733853klaxon
klong105310403k_l_ong
kloof123812133k_loof
koels94613903koels__
kolhoz2264773kolhoz
kolkoz1864283kolkoz
kolo87026223kol_o_
kolos94921213kol_os
kroon94514483k_roon
kusso9398033kusso_
kussos10336423kussos
legion75712983legion
lemon75618183le_mon
lepton82510803lepton
lesion64715063lesion
lessen64212433lessen
lessons73811023lessons
lessor64010603lessor
leukon1036143leukon
lion46334443__lion
loon47344793__loon
malison939693malison
mason74820183_mason
mellow114112223mellow
melons84117713mel_ons
mels65941533mels__
meltons9410923meltons
merlon83012353merlon
mesons83215843me_sons
messan83912063messan
nekton1036583nekton
neocon836713neocon
neon47026423ne__on
neuron6310373neuron
neuston736083neuston
newton936983newton
nylon82910513nyl_on
orison6411663orison
orlon5415003orl_on
parson83817903parson
peasen84815963peasen
peloton938743peloton
pennon8310643pennon
pension9412203pension
peon65635243pe__on
pepsin10310853pepsin
pereon83517453pereon
perron83216623perron
persona92812453persona
persons93717013persons
peso66925823pe_so_
pesos77221623pe_sos
pleon74216383_pleon
poison8312223poison
prison8514023prison
pulsion938393pulsion
pylon103614003pyl_on
ramson8310463ramson
reasons72514943reasons
reckon123010543reckon
recon75624243re_con
redon65424883re_don
region74614903region
reloan6415693reloan
relook104813743relook
resin54131053re_sin
resod64720053re_sod
resow88217243re_sow
resown94112923re_sown
rewon86920583re_won
salmon84614183salmon
salon55228553sal_on
saloon64418023saloon
seasons72614233seasons
seisin63715123seisin
seisor63712343seisor
seldom939413seldom
sels46345983sels__
selsyns1092943selsyns
sensor63813843sensor
sermon8413553sermon
session739763session
seton55223543se_ton
sexton133610793sexton
skeleton1244473skeleton
solion6616383solion
solon55026133sol_on
son37761953___son
stemson945163stemson
stepson945673stepson
stetson745783stetson
talion6317713talion
talon55824113tal_on
teflon937453teflon
telamon936523telamon
telco7511873telco_
telcos8710683telcos
teloi54217383tel_oi
telos55424523tel_os
tels46841693tels__
telsonic1045993telsonic
tendon7312033tendon
tenon53320513te_non
tension7311803tension
tensor63812673tensor
teston6313303teston
treason748763treason
unison649033unison
venison1036443venison
version10310923version
verso85314633verso_
versos93812803versos
weakon13357623weakon
weapon11288113weapon
weasons102310583weasons
weldor10317653weldor
welkin1337313welkin
welsh113110363wels_h
xenon122612453xe_non
yellow12429883yellow

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.390458182.1
2DLD Change Limit1127162794.68624053.8
3Display Results2792790.0962906.3
 (SQL Overall)1786912795.17234549.7
 
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.