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

154 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
balcony143585(None) 
bacon95620592ba_con_
bacons104917582ba_cons
ballon84117492ballon_
ballons93916962ballons
baloney1237482bal_oney
barony115915302ba_rony
falcon11310292falcon_
falconry1642532falconry
falcons1239122falcons
abalone938903abal_one
abscond1244503abscond
agony96415653_a_gony
alcove1178083_alcove
alimony1236013_alimony
alkoxy2033343_alkoxy
allonym1244733_allonym
alloy85519973_allo_y
almond91410433_almond
almondy13144483_almondy
almonry12104733_almonry
alone55732963_al_one
along65419493_al_ong
ancon75718233_ancon_
ancone83916953_ancone
astony9510523_astony
atony87218853_a_tony
baboon103613913baboon_
baboons113211083baboons
balboa10389963balbo_a
balboas113710073balboas
balconied1444843balconied
balconies1347743balconies
balding114015063balding
baldly12479833bal_dly
baldy115518933bal__dy
baleen8613053baleen_
baleens938473baleens
baling94829693bal_ing
balkily16266693balkily
balking143717353balking
balky145418243bal__ky
balling104424763balling
ballonet10314503ballonet
ballonne1045243ballonne
balloon93711433balloon
balloons103110523balloons
ballot84624093ballo_t
ballots94116033ballots
ballsy11508873bal_lsy
bally105530103bal__ly
balmily14216463balmily
balmy125217473bal__my
baloneys1334663bal_oneys
banco94019393banco__
bancos104713893banco_s
barny105821733ba__rny
baron78131243ba_ron_
barong96015823ba_rong
barons85025383ba_rons
baryon111211613baryon_
baryons121010473baryons
basion84315853basion_
basions94213953basions
batboy1387533batbo_y
baton75822423ba_ton_
batons85519423ba_tons
bausond1044493bausond
bawcock20144033bawcock
beacon10511373beacon_
beacons11410733beacons
belon73924113bel_on_
belong93411043bel_ong
belons84119413bel_ons
betony114211583b_etony
billon83713833billon_
billons93013363billons
billowy15366903billowy
biltong1034683biltong
blackly1835253blackly
blazon1736763blazon_
blazonry2242163blazonry
blazons1836163blazons
blenny1156203b_lenny
blocky17388353b_locky
blond85618373b_l_ond
bloody124710173b_loody
blooey115110793b_looey
bloomy134510113b_loomy
blowy134315323b_l_owy
boloney1247763bol_oney
bolson8410683bolson_
bolsons969483bolsons
bony96732083b___ony
briony1149043b_riony
bryony1435833b_ryony
buttony1236173buttony
caconym1644953ca_conym
calcedony1752083calcedony
calcify1735873calcify
calcine11315273calcine
calory11312843cal_ory
calumny1443863calumny
calzone1848623calzone
colony115417273col_ony
cony96537833___cony
dalton7311273dalton_
daltons8310403daltons
falconer1346033falconer
falconet13410353falconet
felony123710323fel_ony
flacon1138633flacon_
flacons1238053flacons
gallon73715813gallon_
gallons83015953gallons
garcon92912483garcon_
garcons102411643garcons
gascon9339723gascon_
gascons10289103gascons
halcyon1543923halcyon_
halcyons1644023halcyons
halon86124863hal_on_
halons95720713hal_ons
harmony1538173harmony
incony1139083_incony
jalopy18325863jal_opy
jargony1834493jargony
kalong1177703kal_ong
larceny1234853larceny
loony86918963__loony
macon94519953ma_con_
macons104017243ma_cons
mascon103612743mascon_
mascons113411583mascons
palimony1544303palimony
racon75422143ra_con_
racons84319343ra_cons
sallowy13369343sallowy
salmon84614183salmon_
salmons93713263salmons
salon55228553sal_on_
salons63823693sal_ons
saloon64418023saloon_
saloons74415323saloons
saxony1636233sa_xony
talcing103111633talcing
talcky15294723talc_ky
talcose938133talcose
talcous939483talcous
talion6317713talion_
talions7314113talions
tallowy13347633tallowy
talon55824113tal_on_
talons64019443tal_ons

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.390458182.1
2DLD Change Limit1340271545.89022755.0
3Display Results1541540.0632444.4
 (SQL Overall)1786911546.34328171.4
 
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.