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

155 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
deaconed123749(None) 
beaconed1336981beaconed
deacon9510422deacon__
deaconess1245542deaconess
deaconry1443322deaconry
deacons10310392deacon_s
deadened1137232deadened
deafened1335852deafened
deaned84620452dea__ned
deboned113411632de_boned
decoded123212392de_coded
decoyed14358342de_coyed
deponed113712872de_poned
reasoned9410732reasoned
seasoned948112seasoned
weaponed1445502weaponed
acned87520673__ac_ned
acorned10238283__acorned
atoned75417543__atoned
beached154516553beac_hed
beacon10511373beacon__
beacons11410733beacon_s
beaned95621473bea__ned
beckoned1735793beckoned
blazoned2044313blazoned
braconid1345633braconid
coned86040053___coned
crayoned1435003crayoned
dadoed9449903d_ado_ed
daemones11209163daemones
damned104212913d_a_mned
darned85018483d_a_rned
davened124610073d_avened
dawned113912093d_a_wned
deaconing1337193deaconing
deaconries1345173deaconries
deadener1036743deadener
deadlined12125323deadlined
deaired9411533dea_ired
dealated103213603dealated
deashed123411303dea_shed
deathbed1543393deathbed
deaved114916553dea__ved
debone93714783de_bone_
deboner103110483de_boner
debones103315113de_bones
decamped1634973decamped
decane93818873de_cane_
decanes103118913de_canes
decanted122310493decanted
decayed14309333de_cayed
decerned1237263decerned
decided124312423de_cided
decked145217623de_c_ked
declined123910883declined
decocted1437693de_cocted
decode104414743de_code_
decoder113712293de_coder
decodes113914983de_codes
decoyer13348683de_coyer
decreed112710263de_creed
decried112612863de_cried
decrowned1663663decrowned
deepened1235663deepened
defaced142910973defac__ed
defined123813823de_fined
dehorned1345683dehorned
deiced104214483deic__ed
deigned1037503de_igned
demagoged15103643demagoged
demeaned1237283demeaned
demoded123611123de_moded
demoed103713443de_mo_ed
demoted114313543de_moted
denned84215633de__nned
denoted93512763de_noted
deplaned1238663deplaned
deplored1237233deplored
deployed1535913deployed
depone93616553de_pone_
depones103717093de_pones
deposed113412033de_posed
deraigned1244093deraigned
descanted1336673descanted
descend11248153descen_d
descended1446283descended
descried1248083descried
designed1136943designed
despond1137513despon_d
desponded1445323desponded
destined103312453destined
detached1537733detac_hed
detained103111643detained
dethroned1445073dethroned
detoxed1636103de_toxed
deuced104112123deuc__ed
deveined1336673deveined
devoted124111093de_voted
dewooled1333833dewooled
diaconal1196133diaconal
dialoged1146693dialoged
diamond1186113diamon_d
diamonded1443393diamonded
discoed11312483disco_ed
doggoned1243883doggoned
draconic1346203draconic
dragonet10138953dragonet
dragooned1242963dragooned
drained93713253dra_ined
droned84616863d__roned
earned74818333_ea_rned
encoded1139043_encoded
encored10412113_encored
escoted1038183_escoted
jaconet16311483_jaconet
jeaned143813463jea__ned
leached133715043leac_hed
leadened1036153leadened
leaned73422543lea__ned
learned8329303lea_rned
leavened1235553leavened
lesioned936903lesioned
lessoned945393lessoned
masoned1039803_masoned
neatened937043neatened
neoned7311493ne__oned
peaced115818913peac__ed
peached154315883peac_hed
peacocked2042863peacocked
pennoned1136313pennoned
reached134619083reac_hed
reacted103015713reac_ted
readorned1145183readorned
reasoner849343reasoner
reavowed1534683reavowed
recaned102817203re_caned
reckoned1546963reckoned
recoded113115043re_coded
recoined113614433re_coined
reconned113610663re_conned
rescored114513103rescored
rezoned173611163re_zoned
seasoner857693seasoner
second9411153se_con_d
seconde1037413se_conde
seconded1236363se_conded
taloned8310223_taloned
tenoned839363te_noned
unatoned939423unatoned
wagoned1256223_wagoned
weakened1634823weakened
weaned103816153wea__ned
welcomed1643333welcomed
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.420425454.8
2DLD Change Limit1461621557.68619016.7
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.16921874.3
 
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.