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

114 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
beaconing143663(None) 
deaconing1337191deaconing
beaching164114142beac_hing
beaning103820682bea__ning
beckoning1845772beckoning
becoming1538162be_coming
blazoning2144032blazoning
reasoning10310202reasoning
seasoning1037412seasoning
weaponing1545382weaponing
atoning83514873__atoning
baching156017753b_ac_hing
backing165523443b_ac_king
baning95127833b_a__ning
banning103818233b_a_nning
barning104320353b_a_rning
beacon10511373beaco__n_
beaconed1336983beacon_ed
beacons11410733beaco__ns
beading113221863bea__ding
beaming123618803bea__ming
bearding124011943bea_rding
bearing103624773bea__ring
beating104326873bea__ting
beavering1538703beavering
becalming1635283becalming
becapping1834243becapping
becking164416073be_c_king
beclowning1843423beclowning
becomings1643783be_comings
bedamning1534183bedamning
beelining1236593beelining
befooling1535053befooling
beginning1344613beginning
begroaning14114113begroaning
behooving1843743behooving
behoving1734913be_hoving
belaboring1544033belaboring
belching16349153belc_hing
bellowing1547193bellowing
belonging1335913be_longing
bemeaning1436193bemeaning
bemoaning1435953bemoaning
bemocking2034653bemocking
benching163411343benc_hing
bescouring1584643bescouring
besmoking18114613besmoking
besnowing1544123besnowing
bestowing1535803bestowing
bethorning1644203bethorning
blackening1944793blackening
blacking174213603blac_king
blazonings2241983blazonings
bleaching17287093bleac_hing
boning94223293b___oning
bracing123817613brac__ing
braconid1345633braconi_d
braconids1444193braconids
braining113414683bra_ining
branning112911093bra_nning
bravoing1445993bravo_ing
brazening2185183brazening
breaching17269403breac_hing
buncoing13337813bunco_ing
buttoning1246463buttoning
coning94331823___coning
crayoning1535243crayoning
deadening1277583deadening
deafening1476273deafening
deaning94020473dea__ning
deboning12109153de_boning
decoding132410053de_coding
decoying15208763de_coying
deponing121211213de_poning
earning83418213_ea_rning
encoding1239043_encoding
encoring11312173_encoring
escoting1158713_escoting
leaching143012833leac_hing
leadening1176733leadening
leaning83721203lea__ning
learning978553lea_rning
leavening1365973leavening
lesioning1046443lesioning
lessoning1044773lessoning
masoning1139763_masoning
meaning103918703mea__ning
neatening1038353neatening
peaching163613643peac_hing
peacing124117073peac__ing
peacocking2143313peacocking
reaching143317203reac_hing
reacting113317893reac_ting
readorning1245723readorning
reasonings1143653reasonings
reavowing1634863reavowing
recaning111416693re_caning
reckoning1637643reckoning
recoding122213853re_coding
recoining121313803re_coining
reconning121410793re_conning
rescoring12310603rescoring
rezoning18310453re_zoning
seagoing1038193seago_ing
seasonings1143293seasonings
seconding1337613se_conding
teaching143612603teac_hing
tenoning938893te_noning
wagoning1336923_wagoning
weakening1734843weakening
weaning114117193wea__ning
welcoming1743473welcoming
yeaning113814633yea__ning
yearning1296983yea_rning

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411146.93621430.4
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.40524131.1
 
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.