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

240 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
kelsons113732(None) 
keelsons1244091keelsons
kelson1038151kelson_
nelsons738001nelsons
telsons739221telsons
belons84119412bel_ons
bolsons969482bolsons
felons93615762fel_ons
keelson1153992keelson_
kelvins14106562kelvins
lessons73811022lessons
melons84117712mel_ons
meltons9410922meltons
mesons83215842me_sons
nelson638422nelson_
persons93717012persons
reasons72514942reasons
seasons72614232seasons
selsyns1092942selsyns
telson6310292telson_
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
censors93611843censors
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
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
kalians11310183kalians
kalong1177703kal_ong
kalongs1255443kal_ongs
kamsins1346963kamsins
kaons95014853k__aons
kations114013663kations
kebobs14427293ke_bobs
keens95721183ke__ens
keeshond1643183keeshond
keeshonds1742583keeshonds
keleps12478813kel_eps
kelims1278913kel_ims
kellies113516853kellies
keloid11812623kel_oid
keloids1288663keloids
kelpies13289903kelpies
kelping14319193kelping
kelps115116423kel__ps
kelters113813753kelters
kelts95222633kel__ts
kelvin13117323kelvin_
kendos114510663kendo_s
kenos95220623ke_no_s
kenosis11369003kenosis
kens85435233ke___ns
kerns94719563ke__rns
kerseys1433993kerseys
ketols104210763ke_tols
ketone105014533ke_tone
ketones115014503ke_tones
ketoses114912873ketoses
ketosis11429733ketosis
keysets1434343keysets
keystone1545333keystone
keystones1645083keystones
kilns95112983kil__ns
kilos95021473kil_o_s
kilotons1286313kilotons
klaxons1833263klaxons
klong105310403k_l_ong
klongs11436603k_l_ongs
kloofs13386353k_loofs
kolos94921213kol_o_s
kroons103711243k_roons
kussos10336423kusso_s
legions84611783legions
lemons84415053le_mons
leptons91910433leptons
lesions73813873lesions
lessens7409383lessens
lesson64412043lesson_
lessors73610523lessors
leukons1135753leukons
lions55923213__lions
loons55731723__loons
malisons1048783malisons
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
saloons74415323saloons
season62714903season_
seisins73614393seisins
seisors73212843seisors
selsyn983843selsyn_
sensors73514643sensors
sermons9311783sermons
sessions839723sessions
setons64620173se_tons
sextons143710413sextons
skeletons1343933skeletons
solions7513753solions
solons65120023sol_ons
sons46049553___sons
stemsons1045003stemsons
stepsons1045663stepsons
stetsons845623stetsons
talions7314113talions
talons64019443tal_ons
teflons1036543teflons
telcos8710683telco_s
telos55424523tel_o_s
telsonic1045993telsonic
tendons8311473tendons
tenons62916603te_nons
tensions8310223tensions
tensors72712373tensors
testons7313563testons
treasons848683treasons
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.440406115.9
2DLD Change Limit1340272405.71623447.7
3Display Results2402400.0803000.0
 (SQL Overall)1786912406.23628654.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.