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

192 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
baronne93826(None) 
baronnes1038551baronnes
ballonne1045242ballonne
baron78131242baro_n_
baronage1147072baronage
baronet91022202baronet
barong96015822baro_ng
barongs105310832barongs
baronies10315022baronies
barons85025382baro_ns
barony115915302baro_ny
baroque1835102baroque
bonne75124712b__onne
bronze173610922b_ronze
abalone938903abalo_ne
agone65924553_ago_ne
alone55732963_alo_ne
amarone9311203amaro_ne
arcane81216743_arcane
arene55329413_ar_ene
aroint6328153_aroint
arose55832083_aro_se
around72712413_around
arouse65019983_arouse
aroynt9312893_aroynt
arsine64021043_arsine
atone56527983_ato_ne
axone125918473_axo_ne
baboon103613913baboon_
baboons113211083baboons
bacon95620593baco_n_
bacons104917583baco_ns
balance11510263balance
ballonnes1145323ballonnes
baloney1237483baloney
bane65250433ba___ne
banned94721343ba__nned
banner84421503ba__nner
bannet84925333ba__nnet
banns75321233ba__nns
barbate11314543barbate
barbe95328283bar__be
barbie105018353bar_bie
barbing123716993barbing
barbule1137943barbule
barde85330773bar__de
barding113822893barding
bare65460523bar___e
barege94713543bar_ege
barfing134615093barfing
barge85631023bar__ge
bargee94624443bar_gee
barging114018483barging
baring95135853bar_ing
barite84224813bar_ite
baritone1058643baritone
barking144724183barking
barman103519703barman_
barmen105418533barmen_
barmie103816393bar_mie
barn66444643bar__n_
barned95623583bar_ned
barney115314453bar_ney
barnier93213673bar_nier
barning104320353barning
barns76335143bar__ns
barny105821733bar__ny
baronages1247153baronages
baroness101210063baroness
baronets101410903baronets
baronial1049483baronial
baroques1934863baroques
barouche1544173barouche
barque17239553bar_que
barrage10710843barrage
barre75929543bar__re
barren85317613barren_
barrener1038333barrener
barrens94414323barrens
barring104021593barring
bartend1038753bartend
barware12610703barware
barye105021493bar__ye
baryon111211613baryon_
baryonic1546203baryonic
baryons121010473baryons
baryte115312883bar_yte
barytone1356023barytone
baton75822423bato_n_
batons85519423bato_ns
bayonet121212213bayonet
begone9512133bego_ne
benne76521123b__enne
berline93716853berline
bicorne11297553bicorne
bizone1738603bizo_ne
blonde94813293b_londe
bone65949323b__o_ne
bonnes85621453b__onnes
bonnet85524633b__onnet
bonnie85314853b__onnie
bonny105816623b__onny
bonze165119353b__onze
borane84620213bor_ane
borne77926793b__orne
boron76727143boro_n_
boronic11311163boronic
borons85520543boro_ns
botonee9311833botonee
botonnee1044693botonnee
branned104311693b_ranned
branner94212373b_ranner
branny115111833b_ranny
brine75132273b_r_ine
broche133612103b_roche
brogue94211033b_rogue
broke116019783b_ro_ke
broken124011523b_roken
brome94421973b_ro_me
bromine112915243b_romine
bronc91714343b_ro_nc
bronco10179493b_ronco
broncs101611153b_roncs
bronzed19308213b_ronzed
bronzer18348493b_ronzer
bronzes183510403b_ronzes
bronzy20306713b_ronzy
brose75227033b_ro_se
brown105619533b_rown_
browned134710973b_rowned
browner124911643b_rowner
brownie12178433b_rownie
browns116415633b_rowns
browny144510043b_rowny
browse115713853b_rowse
burnie83715413bur_nie
bygone1256173bygo_ne
byrnie11348573byr_nie
carbine112918643carbine
carinae94318593carinae
carline93923613carline
carmine112918483carmine
carnie84421093car_nie
caroche1469243caroche
carotene1039133carotene
carouse9614423carouse
cayenne1244603cayenne
chaconne1543933chaconne
coronae94214893coronae
crone75231333_cro_ne
donne65520463__donne
drone65324983_dro_ne
garote7717953garo_te
garotte868703garotte
groyne1037213_groyne
harmine122816193harmine
heroine103517483heroine
irone55126363_iro_ne
krone94018733_kro_ne
kronen10348913_kronen
ladrone83611873ladro_ne
larine63927043lar_ine
madonna1044403madonna
madrone102812663madro_ne
marine84230403mar_ine
marline93320953marline
maroon83118203maroon_
marooned1138563marooned
maroons92615553maroons
nardine82712573nardine
narine63422553nar_ine
padrone102512073padro_ne
panne76623653pa__nne
pardine103616723pardine
parole84425253paro_le
parolee94119643parolee
paronym1437503paronym
pavonine1346663pavonine
prone75332623_pro_ne
pyrone112714473pyro_ne
pyronine1349513pyronine
raisonne843813raisonne
ronnel63310883__ronnel
saponine1039223saponine
sardine83317393sardine
sarode75317513saro_de
sarong73914873saro_ng
sarongs84511803sarongs
throne98517603thro_ne
tonne54921433__tonne
trone55131863_tro_ne
warbonnet1444923warbonnet

Search took 8 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.406440125.6
2DLD Change Limit1340271927.31318327.2
3Display Results1921920.0762526.3
 (SQL Overall)1786911927.79522923.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.