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

151 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
barons8502538(None) 
bacons104917581bacons
barns76335141bar_ns
baron78131241baron_
barong96015821barong
barongs105310831barongs
barony115915301barony
baryons121010471baryons
batons85519421batons
borons85520541borons
aeons57624652_aeons
agons66423782_agons
aprons8316992aprons
argons75018202_argons
arsons63917212_arsons
axons125517932_axons
azons146518252_azons
baboons113211082baboons
baboos103517012baboos
bacon95620592bacon_
bairns86710872bairns
ballons93916962ballons
banns75321232ba_nns
bans66555142ba__ns
barbes104526232barbes
barbs95928192bar_bs
barcas101016602barcas
bardes95026932bardes
bards87139642bar_ds
bares75457132bar_es
barfs104826002bar_fs
barges94528252barges
barhops14288112barhops
baring95135852baring
barks115735812bar_ks
barlows12259972barlows
barms96128462bar_ms
barn66444642bar_n_
barny105821732bar_ny
baroness101210062baroness
baronet91022202baronet
baronets101410902baronets
baronies10315022baronies
baronne938262baronne
baronnes1038552baronnes
barrens94414322barrens
barres84427542barres
barrows123411682barrows
bars66564092bar__s
baryes116218502baryes
baryon111211612baryon_
barytons1345572barytons
basins85722762basins
basions94213952basions
baton75822422baton_
baudrons1135762baudrons
bayous11411152bayous
bazoos173212622bazoos
beacons11410732beacons
belons84119412belons
betons84919552betons
bicrons113410472bicrons
biros75325132biro_s
bisons83914372bisons
blazons1836162blazons
boons75031912b_oons
boron76727142boron_
bosons85016652bosons
brains85125472brains
brans75437432b_rans
brawns115614082brawns
brens75823362b_rens
brins75533972b_rins
bronc91714342b_ronc
broncs101611152b_roncs
broos75126412b_roos
bros65635662b_ro_s
browns116415632b_rowns
brows105425982b_rows
burans85019302burans
burins84221892burins
burns74926782bur_ns
burtons9310852burtons
canons85522062canons
capons104119502capons
carbons115418942carbons
cardons104519942cardons
carns75937562car_ns
carobs104818102carobs
carols85124982carols
caroms105619572caroms
cartons94122472cartons
dacrons103211032dacrons
darns66927892dar_ns
earns55927562ear_ns
fanons96115212fanons
faros85532022faro_s
frons86124042_frons
garcons102411642garcons
garrons82713462garrons
girons75014372girons
gyrons105511222gyrons
hadrons113314302hadrons
halons95720712halons
herons94820542herons
irons55324132_irons
jargons1558202jargons
kaons95014852ka_ons
karns96624142kar_ns
karoos102415802karoos
kaross101910012kaross
ladrons83813192ladrons
lardons83914492lardons
macons104017242macons
macrons113514892macrons
maroons92615552maroons
marrons93216972marrons
masons83916512masons
matrons93517632matrons
morons84919542morons
natrons73215662natrons
paeons83915522paeons
pardons103817622pardons
parols84722612parols
parous84024162parous
parsons93516872parsons
partons94620512partons
patrons93818102patrons
racons84319342racons
radons74118532radons
rayons94113342rayons
salons63823692salons
sarans64224432sarans
sarins63932622sarins
sarods74918572sarods
sarong73914872sarong
sarongs84511802sarongs
saros55238062saro_s
talons64019442talons
tarns56433952tar_ns
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
tarpons92612212tarpons
tauons63412672tauons
taxons134211502taxons
wagons103911212wagons
warns87231002war_ns
yapons114411772yapons
yarns85621792yar_ns

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit825511512.75030018.5
3Display Results1511510.0463282.6
 (SQL Overall)1786911513.13956926.1
 
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.