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 “beheaders” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
beheaders154515(None) 
beheader1436041beheader_
beaders104120182b__eaders
behavers16205612beh_avers
beheadals1542092beheadals
beheaded1536372beheade_d
beheads1338522behead__s
beholders1544932beholders
bereavers1446122bereavers
headers113819392__headers
reheaters122010272reheaters
bahadurs1442553bah_adurs
beader94623793b__eader_
beakers134216873b__eakers
bearers94619593b__earers
beaters94925043b__eaters
beavers124417323b__eavers
bedders113513383b__edders
bedeafens1542413bedeafens
bediapers1444333bediapers
bedmakers1844383bedmakers
beefeaters1553233beefeaters
beepers113612383be_e_pers
beetlers1037393be_etlers
beezers18349243be_e_zers
begetters12135043begetters
behaver15206723beh_aver_
behaves15198523beh_ave_s
behead1239923behead___
beheadal1442813behead_al
beheading1636163beheading
beholder1435053beholder_
bejabers1933633be_jabers
bejeebers2042283bejeebers
belayers13298143be_layers
beleaguers1342373beleaguers
benders104021063b__enders
bereaver1346673bereaver_
bereaves1338273bereave_s
besetters11136633besetters
besmearers1442823besmearers
betrayers1445013betrayers
bevelers13389453beve_lers
bevellers14276113bevellers
bewilders1543813bewilders
bewrayers1743483bewrayers
bladers104214683b__laders
bleaters103412323b_leaters
bleeders11448453b_leeders
blenders115210993b_lenders
breakers143810973b_reakers
breeders11368893b_reeders
cheaters133613513_cheaters
cheders134512393_che_ders
coleaders1237823coleaders
defeaters13289103defeaters
defenders1436363defenders
degenders1236083degenders
degraders12245933degraders
emenders11319033_emenders
evaders1136933_e_vaders
feeders113712863fe_e_ders
header104422543__header_
healers104319463__healers
heapers123616673__heapers
hearers104319783__hearers
heaters104225223__heaters
heavers133717193__heavers
heders104119763__he_ders
heeders114213743__heeders
herders113914123__herders
kneaders1384713_kneaders
leaders83819603__leaders
needers84111903ne_e_ders
pervaders1544433pervaders
pleaders113210183_pleaders
preheaters1557193preheaters
readers83823773__readers
rehears103312773rehea__rs
rehearsers13273863rehearsers
reheater113413033reheater_
releasers937323releasers
reloaders1036423reloaders
repealers11278843repealers
repeaters112811993repeaters
repleaders1344033repleaders
revealers12318243revealers
seceders11277963sece_ders
seeders83017113se_e_ders
serenaders11204663serenaders
shaders115915553_sh_aders
shearers113911323_shearers
shedders13267433_shedders
spreaders1236503spreaders
theaters114211903_theaters
threaders1365743threaders
treaders93311843_treaders
upheavers1742593upheavers
weeders113412933we_e_ders

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.420425454.8
2DLD Change Limit148641996.97021325.8
3Display Results99990.0462152.2
 (SQL Overall)178691997.43624030.5
 
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.