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

247 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
baloney123748(None) 
baloneys1334661baloneys
boloney1247761boloney
abalone938902abalone_
abalones1038752abalones
alone55732962_alone_
balcony1435852balcon_y
ballonet10314502ballonet
barney115314452ba_rney
baronet91022212baronet
barony115915302baron_y
bayonet121212212bayonet
blarney12174762blarney
blooey115110792b_looey
boloneys1334502boloneys
boney105227312b__oney
taloned8310222taloned
agone65924553_agone_
agones75719863_agones
agony96415653_agon_y
alane56135613_alane_
aline57243163_aline_
alined75221413_alined
aliner65621993_aliner
alines65735233_alines
alley85721673_al_ley
almner85710723_almner
almondy13144483_almondy
almoner949383_almoner
almonry12104733_almonry
aloe45540193_alo_e_
aloes54933673_alo_es
along65419493_alon_g
atone56527983_atone_
atoned75417543_atoned
atoner64817193_atoner
atones65225773_atones
atony87218853_aton_y
axone125918473_axone_
axones134614513_axones
baboonery1642333baboonery
baclofen1543103baclofen
bacon95620593bacon__
bacons104917583bacon_s
bailey115015673ba_iley
bairnly1234503bairnly
balance11510263balance
balanced1356513balanced
balancer1246603balancer
balances1279973balances
balases93815433balases
balconied1444853balconied
balconies1347753balconies
balded105417513bal_ded
balder95318863bal_der
baldies105317703baldies
baldly12479833bal_dly
baldness1137043baldness
baldy115518933bal__dy
bale66353843bal__e_
baled85436443bal__ed
baleen8613053bal_een
baleens938473baleens
baler75635283bal__er
bales76250083bal__es
baling94829693balin_g
balked135219413bal_ked
balker124519163bal_ker
balkier134111983balkier
balkily16266693balkily
balky145418243bal__ky
balled94926893bal_led
baller83825203bal_ler
ballet84733973bal_let
ballies93725743ballies
ballon84117493ballon__
ballonets1146723ballonets
ballonne1045243ballonne
ballonnes1145323ballonnes
ballons93916963ballon_s
ballooned1245103ballooned
balloted1189043balloted
balloter1078893balloter
ballsy11508873bal_lsy
bally105530103bal__ly
balmier113811513balmier
balmily14216463balmily
balmy125217473bal__my
balneal936573bal_neal
bandy114824193ba__ndy
bane65250433ba__ne_
baned85436353ba__ned
banes74945583ba__nes
banned94721343ba_nned
banner84421503ba_nner
bannet84925333ba_nnet
banty106624003ba__nty
barley115116763ba_rley
barned95623583ba_rned
barneys12569563ba_rneys
barny105821733ba_rn_y
baron78131243baron__
baroness101210063baroness
baronetcy1642543baronetcy
baronets101410913baronets
barong96015823baron_g
barongs105310833barongs
baronies10315023baronies
baronne938273baronne
baronnes1038553baronnes
barons85025383baron_s
basined10310003basined
basinet9318933basinet
baton75822423baton__
batons85519423baton_s
bayonets13135583bayonets
beaconed1336983beaconed
begone9512133begone_
belon73924113belon__
belong93411043belon_g
belonged1235313belonged
belongs10408223belongs
belons84119413belon_s
beloved13188393beloved
betony114211583beton_y
bilobed1235913bilobed
bizone1738603bizone_
bizones1837823bizones
blarneys13183193blarneys
blazoned2044313blazoned
blazoner1944133blazoner
blazonry2242163blazonry
blenny1156203b_lenny
blimey13468453b_limey
blocky17388353b_locky
bloke114316633b_loke_
blokes123813883b_lokes
blond85618373b_lon_d
blonde94813293b_londe
blonder104011953b_londer
blondes104213163b_londes
blonds95213343b_londs
bloody124710173b_loody
bloomy134510113b_loomy
blotty11178343b_lotty
blousy11459123b_lousy
blowby16467513b_lowby
blowed125016693b_lowed
blower115316573b_lower
blowsy14579453b_lowsy
blowy134315323b_lo_wy
blowzy23516673b_lowzy
bluey104817053b_l_uey
bogey115220233b__ogey
bone65949323b__one_
boned85133243b__oned
boner75133083b__oner
bones76446533b__ones
bonny105816623b__onny
bony96732083b__on_y
boogey124711523b_oogey
botonee9311833botonee
briony1149043brion_y
bronzy20306713b_ronzy
bryony1435833bryon_y
bygone1256173bygone_
bygones1335913bygones
byline11311643byline_
bylined1335853bylined
byliner1235723byliner
bylines1239243bylines
cajones163311333cajones
calomel1138073calomel
calory11312843calo_ry
caloyer1238143caloyer
calzone1848623calzone_
calzones1948763calzones
canonry1235923canonry
carney115315703ca_rney
chalone12312103chalone_
chalones13312173chalones
clone75728163_clone_
cloned94518803_cloned
cloner84418093_cloner
clones84526563_clones
colone85425003colone_
colonel94213283colonel
colones96124433colones
colony115417273colon_y
coney105932883__coney
falconer1346043falconer
falconet13410363falconet
falconry1642543falconry
felonry13294843felonry
felony123710323felon_y
flooey123910173_flooey
galley104215453gal_ley
galoped11138083galoped
galore73514873galore_
galores82614343galores
gooney106612313_gooney
hackney1935123hackney
haloed104717603halo_ed
haloes94623863halo_es
halogen1138393halogen
halon86124863halon__
halons95720713halon_s
honey115629913__honey
jaconet16311483jaconet
jaloppy21302483jaloppy
jalopy18325863jalo_py
kalong1177703kalon_g
kalongs1255443kalongs
liney87029633__liney
lone45849133__lone_
lonely92912473__lonely
loner55431043__loner
looey84822913__looey
looney94712413_looney
maline84529103maline_
malines93625623malines
malmsey1433623malmsey
masoned1039803masoned
masonry1244123masonry
money104826843__money
palfrey1533343palfrey
phoney143612983_phoney
saline65132713saline_
salines74029423salines
salon55228553salon__
salons63823693salon_s
sawney12387603sa_wney
saxony1636233saxon_y
spooney12418243spooney
stoney96217353_stoney
talon55824113talon__
talons64019443talon_s
tawney12338233ta_wney
toney86027413__toney
valency1565463valency
valine94623103valine_
valines104520223valines
valley124311603val_ley
valonia1048303valonia
wagoned1256223wagoned
wagoner1136093wagoner
waney115120323wa__ney

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 Limit1340272477.14018771.3
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.63923391.9
 
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.