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 “salon” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

138 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
salon5522855(None) 
halon86124861halon
salmon84614181salmon
salol55222141salol
salons63823691salons
saloon64418021saloon
solon55026131solon
talon55824111talon
aeon45634612_aeon
agon56531882_agon
alan46844082_alan
aloe45540192_aloe
aloin55227422_aloin
alone55732962_alone
along65419492_along
alow75328592_alow
anon46134852_anon
axon115524302_axon
azlon144312872azlon
azon135725052_azon
bacon95620592bacon
ballon84117492ballon
baron78131242baron
baton75822422baton
belon73924112belon
cajon144513902cajon
calo64936442calo_
calos74431902calos
canon74725302canon
capon95221872capon
clon66232482_clon
colon78630192colon
dalton7311272dalton
etalon648972etalon
falcon11310292falcon
fanon84619012fanon
felon84619292felon
gallon73715812gallon
galop84716222galop
halo76437322halo_
halons95720712halons
halos85230252halos
jalop144212602jalop
kalong1177702kalong
kaon87521022ka_on
macon94519952macon
mason74820182mason
melon73922082melon
nylon82910512nylon
orlon5415002orlon
paeon74819492paeon
pelon74423212pelon
pylon103614002pylon
racon75422142racon
radon64620502radon
rayon83815702rayon
sabin74924952sabin
sabot7931782sabot
sago56332672sago_
sagos66123872sagos
sailor63113752sailor
sain45551292sa_in
sajou12311692sajou
sal36462882sal__
salad65321832salad
salal55425702salal
sale44959702sal_e
salep77022952salep
sales56055592sales
salic73424712salic
salina64221122salina
saline65132702saline
sall44544682sal_l
sallow94315752sallow
sally85129712sally
salmi7815862salmi
salmons93713262salmons
salols64017872salols
saloons74415322saloons
saloop84212582saloop
salp64534092sal_p
salpa75018352salpa
salps74423242salps
sals46851672sal_s
salsa56718922salsa
salt45758522sal_t
salts55431882salts
salty85524382salty
salve85022132salve
salvo84415642salvo
salvor94711092salvor
salvos94613382salvos
sapor75119252sapor
saran53730302saran
sarin55239252sarin
sarod65325872sarod
sarong73914872sarong
saros55238062saros
sasin54626572sasin
satin55935222satin
savin84625082savin
savor85417942savor
savoy114713882savoy
sawlog1035792sawlog
sawn75428162sa_wn
saxony1636232saxony
scion72214992scion
season62714902season
seton55223542seton
shalom11810922shalom
shoon84022012shoon
silo46037912silo_
silos56029432silos
slain54923572slain
slalom888172slalom
slob66029422s_lob
sloe45534952s_loe
slog56728272s_log
slop66533872s_lop
slot46049832s_lot
slow77729492s_low
solan55328152solan
solion6616382solion
solo45538942solo_
solons65120022solons
solos54830792solos
son37761952s__on
soon46240502s_oon
spoon74719442spoon
stolon64112072stolon
swoon85014782swoon
talion6317712talion
talons64019442talons
tauon54816582tauon
taxon124414662taxon
valor83614892valor
wagon94312952wagon
yapon104613582yapon

Search took 5 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 Filter178691538000.330541487.9
2DLD Change Limit538001383.67014659.4
3Display Results1381380.0801725.0
 (SQL Overall)1786911384.08043796.8
 
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.