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

118 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
beckoned173578(None) 
beckoner1654961beckoner
reckoned1546951reckoned
backboned2045472backboned
beaconed1336982beaconed
becked155417762beck__ed
beckon14309382beckon__
beckoners1744062beckoners
beckons15279142beckon_s
beclowned1743242beclowned
reckoner1446062reckoner
backbend1944783backbend
backbone1847443backbone_
backbones1947253backbones
backed155725723back__ed
backhoed2047003backhoed
beaked135919493beak__ed
beaned95621473be__aned
becalmed1534813becalmed
becapped1733933becapped
bechanced1945643bechanced
becket144619883beck__et
becking164416073beckin_g
beckoning1845773beckoning
becloaked1843733becloaked
beclogged1643143beclogged
beclothed1744123beclothed
becloud1246293beclo_ud
beclouded1543503beclouded
become123312593bec_ome_
becomes132911963bec_omes
becrimed1565513becrimed
becrowd1555173becro_wd
becrowded1842923becrowded
becursed1335583becursed
bedamned1434583bedamned
beelined11277713beelined
befooled1434803befooled
begone9512133be_gone_
begroaned13124053begroaned
behooved1743133behooved
behoved16205563be_hoved
bellowed14158603bellowed
belonged1235313be_longed
beloved13188393be_loved
bemeaned1335783bemeaned
bemoaned1335553bemoaned
berobed1238233be_robed
besmoked17405413besmoked
besnowed14124403besnowed
bestowed14156613bestowed
bethorned1544443bethorned
betokened1643403betokened
beyond1237073be_yon_d
bickered17108003bickered
blackened1845273blackened
blazoned2044313blazoned
boned85133243b___oned
bucked155121063buck__ed
bucketed1736763bucketed
buckled164411883buck_led
buckoes153810393bucko_es
bunkoed14356663bunko_ed
buskined1534443buskined
buttoned1137503buttoned
cloned94518803__cloned
cocooned1337293cocooned
coned86040053__c_oned
cuckooed1743303cuckooed
deaconed1237493deaconed
deboned113411633de_boned
decerned1237263decerned
decked145217623deck__ed
declined123910883declined
decoded123212383dec_oded
decoyed14358333dec_oyed
decrowned1663653decrowned
deponed113712873de_poned
echoed125211153_echo_ed
eikones1137853_eikones
gecked146911933geck__ed
geckoes14325793gecko_es
heckled17318463heck_led
hectored1436873hectored
kecked125113163keck__ed
keckled13376503keck_led
lesioned936903lesioned
lessoned945393lessoned
necked134715063neck__ed
necrosed1137213necrosed
neoned7311483ne__oned
pecked155019103peck__ed
pennoned1136313pennoned
reasoned9410733reasoned
recaned102817203rec_aned
recked134821803reck__ed
reckon123010543reckon__
reckoners1545113reckoners
reckons13269653reckon_s
reclined113613603reclined
recoded113115033rec_oded
recoined113614423recoined
reconned113610653reconned
recooked15268243recooked
recrowned1564853recrowned
rezoned173611163re_zoned
seasoned948113seasoned
secerned1136103secerned
second9411153sec_on_d
seconde1037413sec_onde
seconded1236353sec_onded
sectioned1246523sectioned
sectored1138063sectored
sickened1546783sickened
tenoned839363te_noned
vectored1435623vectored
weakened1634823weakened
weaponed1445493weaponed

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.1701051123.5
2DLD Change Limit1461621188.61016975.8
3Display Results1181180.0801475.0
 (SQL Overall)1786911188.86020168.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.