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

124 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
beheader143604(None) 
beheaded1536371beheaded
beheaders1545151beheaders
beader94623792b__eader
behaver15206722beh_aver
behead1239922behead__
beheadal1442812beheadal
beheads1338522behead_s
beholder1435052beholder
bereaver1346672bereaver
header104422542__header
reheater113413032reheater
bahadur1342603bah_adur
bareheaded1763953bareheaded
beaded104922423b__eaded
beaders104120183b__eaders
beadier103513913b__eadier
beaker125520693b__eaker
bearer85323913b__earer
beater84729393b__eater
beaver114819253b__eaver
bedder104215793b__edder
bedeafen1443343bedeafen
bediaper1344933bediaper
bedmaker1744933bedmaker
beefeater1443603beefeater
beefier12329093be_efier
beeper103714093be_e_per
beerier93613023be_erier
beetler938033be_etler
beezer174010523be_e_zer
begetter11136313begetter
behave14209013beh_ave_
behaved16176683beh_aved
behavers16205613beh_avers
behaves15198523beh_aves
beheadals1542093beheadals
beheading1636163beheading
beheld1236413beheld__
beholden1443593beholden
beholders1544933beholders
belayer12339503be_layer
beleaguer1242533beleaguer
beleaped1336103beleaped
bemeaned1335783bemeaned
bender95223303b__ender
bereave1258353bereave_
bereaved1446403bereaved
bereavers1446123bereavers
bereaves1338273bereaves
besetter10137973besetter
besmearer1343163besmearer
besteaded1345043besteaded
betrayer1345643betrayer
beveler124010683beve_ler
beveller13387663beveller
bewilder1434133bewilder
bewrayer1643733bewrayer
bigheaded1743923bigheaded
blader93618583b__lader
bleaker133510533b_leaker
bleater94515303b_leater
bleeder10359643b_leeder
blender104613843b_lender
boneheaded1743903boneheaded
breaded115014063b_readed
breaker133912923b_reaker
breeder103210043b_reeder
broader103412613b_roader
cheaper144010583_cheaper
cheater124816963_cheater
cheder125113493_che_der
coheaded1536603coheaded
coleader1139183coleader
deader84220473__deader
defeater122611663defeater
defender1337293defender
degender1136893degender
degrader11247913degrader
deleaded1148333deleaded
emender10649843_emender
evader1036813_e_vader
feeder103513843fe_e_der
headed114020473__headed
headers113819393__headers
headier113212953__headier
healer94221803__healer
heaper114119523__heaper
hearer94323643__hearer
heater94828303__heater
heaver124819673__heaver
heder95623643__he_der
heeder104216043__heeder
herder104516463__herder
kneader1275893_kneader
leader74824653__leader
needer73614953ne_e_der
pervader1444863pervader
pleader103511753_pleader
preheater1448913preheater
reader73628293__reader
redheaded1545083redheaded
rehear93713223rehea__r
rehearser12265023rehearser
reheated122415003reheated
reheaters122010273reheaters
releaser839503releaser
reloader937913reloader
repealer103210703repealer
repeater102615443repeater
repleader1245393repleader
revealer113110073revealer
seceder10329573sece_der
seeder74320773se_e_der
serenader10216003serenader
shader104218763_sh_ader
shearer104414683_shearer
shedder12339323_shedder
spreader1137483spreader
theater104014253_theater
threader1256733threader
treader84113833_treader
upheaver1643443upheaver
weeder103315513we_e_der

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.423422437.4
2DLD Change Limit1461621247.75018859.6
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.21921741.2
 
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.