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

166 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
beheading163616(None) 
beading113221862b__eading
behaving1735452beh_aving
beholding1634232beholding
beleaping1436742beleaping
bemeaning1436192bemeaning
bereaving1537572bereaving
besteading1446022besteading
breading123515462b_reading
coheading1636622coheading
deleading1237772deleading
heading122919112__heading
rehearing132211762rehearing
reheating132314912reheating
rereading111212712rereading
beadings123711783b__eadings
beaming123618803b__eaming
beaning103820683b__eaning
bearding124011943be_arding
bearing103624773b__earing
beating104326873b__eating
bedding124114483b__edding
bedecking1934283bedecking
bedewing1537143bede_wing
bedraping1535383bedraping
beefing133911473be_e_fing
beeping124013913be_e_ping
beeswing14255763be_eswing
beetling1139283be_etling
befleaing1544023beflea_ing
begazing2136633be_gazing
begetting13186583begetting
beggaring1435183beggaring
begirding1434333begirding
begladding1642663begladding
behead1239923behead___
beheadal1442813behead_al
beheadals1542093beheadals
beheaded1536373behead_ed
beheader1436043behead_er
beheaders1545153beheaders
beheads1338523behead__s
behooving1843743behooving
behoving1734913beh_oving
behowling1843683behowling
beladying1634763be_ladying
belauding1335463belauding
belaying143110603be_laying
bemoaning1435953bemoaning
benaming1339693be_naming
bendaying1634953bendaying
bending114420893b__ending
beraking153612973be_raking
berating113220763be_rating
beseeming1435143beseeming
besetting12268423besetting
beshaming1735673beshaming
besmearing1544323besmearing
bespeaking1944393bespeaking
bespreading1743503bespreading
betaking153010153be_taking
betiding1239913be_tiding
betraying1537713betraying
beveling143011033beve_ling
bevelling15227453bevelling
bewaring14279493be_waring
bewearying1942293bewearying
beweeping1743933beweeping
bewraying1834873bewraying
bielding12237473b_ielding
blading113615363b__lading
blearing113111943b_learing
bleating113514503b_leating
bleeding12359053b_leeding
blending12249963b_lending
breaking153914253b_reaking
breaming133612513b_reaming
breeding123411843b_reeding
brigading1445143brigading
brocading1556253brocading
cheating144014523_cheating
coleading1338523coleading
deadheading1852063deadheading
debeaking1735923debeaking
debearding1543733debearding
deceasing1338403deceasing
deeding103315123de_e_ding
defeating142311973defeating
defending15298353defending
degrading13137373degrading
deleaving1436263deleaving
demeaning1337243demeaning
depending14208783depending
dreading113712803_dreading
emending12298893_emending
evading1237283_e_vading
feeding123515073fe_e_ding
hading113922943__h_ading
headings133510493__headings
healing113922963__healing
heaping133015853__heaping
hearing113324163__hearing
heating114024323__heating
heaving144114763__heaving
heeding123515063__heeding
heehawing1943183heehawing
herding122915123__herding
kneading1436373_kneading
leading93419553__leading
needing93214423ne_e_ding
pervading1636303pervading
pleading123011443_pleading
preheating16310723preheating
reading93327213__reading
receding122713763rece_ding
reeding94124133re_e_ding
refeeding14247933refeeding
regearing112211413regearing
regrading121210203regrading
rehearings14214573rehearings
rehearsing1444343rehearsing
reheeling13218263reheeling
rehemming1734743rehemming
releasing10411013releasing
relending112412023relending
reloading1189883reloading
remending132311313remending
renegading1344593renegading
repealing122513543repealing
repeating122618983repeating
repleading1436623repleading
rereadings12124543rereadings
resealing102115673resealing
reseating102421533reseating
reseeding112410493reseeding
resending112313363resending
respading1338803respading
reteaming122110443reteaming
retearing102214253retearing
rethreading16154283rethreading
retreading12128483retreading
revealing132611883revealing
rewearing132310703rewearing
reweaving16227073reweaving
rewedding1535093rewedding
rewelding1436913rewelding
seceding12288563sece_ding
seeding93719483se_e_ding
serenading1246103serenading
shading123115563_sh_ading
sheafing15329483_sheafing
shealing123415463_shealing
shearing123915903_shearing
sheaving154110253_sheaving
shedding14278113_shedding
shending132511253_shending
spreading1339653spreading
steading103613593_steading
subheading1743793subheading
threading14107593threading
treading103515333_treading
unheeding1446103unheeding
unleading1138673unleading
upheaping1743853upheaping
upheaving1843803upheaving
weeding123815213we_e_ding

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.436409841.7
2DLD Change Limit1486411666.92321470.6
3Display Results1661660.0802075.0
 (SQL Overall)1786911667.43924020.8
 
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.