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

121 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
talon5582411(None) 
etalon648971etalon
halon86124861halon
salon55228551salon
talion6317711talion
talons64019441talons
tauon54816581tauon
taxon124414661taxon
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
etalons739072etalons
falcon11310292falcon
fanon84619012fanon
felon84619292felon
gallon73715812gallon
galop84716222galop
halo76437322halo_
halons95720712halons
halos85230252halos
jalop144212602jalop
kalong1177702kalong
kaon87521032ka_on
macon94519952macon
mason74820182mason
melon73922082melon
nylon82910512nylon
orlon5415002orlon
paeon74819492paeon
pelon74423212pelon
pylon103614002pylon
racon75422142racon
radon64620502radon
rayon83815702rayon
salmon84614182salmon
salol55222142salol
salons63823692salons
saloon64418022saloon
solon55026132solon
stolon64112072stolon
taboo73418092taboo
tabor75518392tabor
tabun75914372tabun
taco67031352taco_
tacos77023552tacos
tailor63412502tailor
tain45548072ta_in
taken94819142taken
takin94921302takin
tala45938052tal_a
talar56225382talar
talas55935892talas
talc66226812tal_c
talcs74817182talcs
tale46154162tal_e
talent6323322talent
taler56034872taler
tales55451372tales
tali46837162tal_i
talions7314112talions
talk86230092tal_k
talks94322692talks
talky126215682talky
tall47240212tal_l
tallol63612222tallol
tallow93714202tallow
talls55133432talls
tally84526862tally
taloned8310222taloned
taluk94812872taluk
talus55423262talus
tampon102911232tampon
tan37167582ta__n
tao38358952ta_o_
taos45541002ta_os
tarn46842722ta_rn
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
tarpon82812802tarpon
tauons63412672tauons
taxol124011362taxol
taxons134211502taxons
teflon937452teflon
teloi54217382teloi
telos55424522telos
telson6310292telson
tenon53320512tenon
tiglon737922tiglon
tigon63914442tigon
tolan55124012tolan
ton310265102t__on
toon47740632t_oon
toyon86715672toyon
valor83614892valor
wagon94312952wagon
yapon104613582yapon

Search took 2 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.296603685.8
2DLD Change Limit538001211.46636698.5
3Display Results1211210.0333666.7
 (SQL Overall)1786911211.79599549.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.