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

142 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
beaconed133698(None) 
deaconed1237491deaconed
beached154516552beac_hed
beacon10511372beacon__
beacons11410732beacon_s
beaned95621472bea__ned
beckoned1735782beckoned
blazoned2044312blazoned
braconid1345632braconid
reasoned9410732reasoned
seasoned948112seasoned
weaponed1445492weaponed
acned87520673__ac_ned
acorned10238273__acorned
atoned75417543__atoned
bached145519893b_ac_hed
backboned2045483b_ackboned
backed155725723b_ac_ked
bacon95620593b_acon__
bacons104917583b_acon_s
balconied1444843balconied
baloney1237483b_aloney
baned85436353b_a__ned
banned94721343b_a_nned
barned95623583b_a_rned
baronet91022203b_aronet
basined10310003b_asined
bayonet121212213b_ayonet
beaches144120653beac_hes
beachhead2042583beachhead
beachier1538803beachier
beaconing1436633beaconing
beaded104922423bea__ded
beaked135919493bea__ked
beamed115720733bea__med
bearded114212133bea_rded
beavered1437503beavered
becalmed1534813becalmed
becapped1733933becapped
becked155417763be_c_ked
beckoner1654963beckoner
beclowned1743243beclowned
become123312593be_come_
becomes132911963be_comes
bedamned1434583bedamned
bedcover1663563bedcover
beelined11277713beelined
befooled1434803befooled
begone9512133be_gone_
begroaned13124053begroaned
behooved1743133behooved
behoved16205563be_hoved
belabored1443813belabored
belaced124112153belac__ed
belched154011843belc_hed
bellowed14158603bellowed
belonged1235313be_longed
beloved13188393be_loved
bemeaned1335783bemeaned
bemoaned1335553bemoaned
bemocked1934073bemocked
benched154713943benc_hed
berobed1238233be_robed
bescoured1444333bescoured
besmoked17405413besmoked
besnowed14124413besnowed
bestowed14156613bestowed
bethorned1544443bethorned
beyond1237073be_yon_d
blacked163613373blac_ked
blackened1845273blackened
blazoner1944133blazoner
bleached16378563bleac_hed
boned85133243b___oned
braced115420603brac__ed
braconids1444193braconids
bracted12410933brac_ted
brained103816103bra_ined
branned104311693bra_nned
bravoed13436113bravo_ed
brazened20134903brazened
breached163411643breac_hed
buncoed12378443bunco_ed
buttoned1137503buttoned
coned86040053___coned
crayoned1435003crayoned
deacon9510423deacon__
deaconess1245543deaconess
deaconry1443323deaconry
deacons10310393deacon_s
deadened1137233deadened
deafened1335853deafened
deaned84620453dea__ned
deboned113411633de_boned
decoded123212383de_coded
decoyed14358333de_coyed
deponed113712873de_poned
earned74818333_ea_rned
encoded1139033_encoded
encored10412103_encored
escoted1038183_escoted
jaconet16311483_jaconet
jeaned143813463jea__ned
leached133715043leac_hed
leadened1036153leadened
leaned73422543lea__ned
learned8329303lea_rned
leavened1235553leavened
lesioned936903lesioned
lessoned945393lessoned
masoned1039803_masoned
neatened937043neatened
neoned7311483ne__oned
peaced115818913peac__ed
peached154315883peac_hed
peacocked2042863peacocked
pennoned1136313pennoned
reached134619083reac_hed
reacted103015713reac_ted
readorned1145183readorned
reasoner849343reasoner
reavowed1534673reavowed
recaned102817203re_caned
reckoned1546953reckoned
recoded113115033re_coded
recoined113614423re_coined
reconned113610653re_conned
rescored114513103rescored
rezoned173611163re_zoned
seasoner857693seasoner
second9411153se_con_d
seconde1037413se_conde
seconded1236353se_conded
taloned8310223_taloned
tenoned839363te_noned
unatoned939423unatoned
wagoned1256223_wagoned
weakened1634823weakened
weaned103816153wea__ned
welcomed1643323welcomed
yeaned103813903yea__ned
yearned11327373yea_rned

Search took 9 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 Filter1786911461620.313570897.8
2DLD Change Limit1461621428.15617920.8
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.53220943.6
 
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.