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

150 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
bedrapes138696(None) 
bedrape1277691bedrape_
bedraped1455811bedraped
bedframes1743012bedframes
bediaper1344932bediaper
bediapers1444332bediapers
bedmates1349182bedmates
bedrails1136292bedrails
berakes134815772be_rakes
berates94126872be_rates
bewraps14135402bewrap_s
drapes95419652__drapes
serapes95218102se_rapes
undrapes1138602undrapes
aerates74627493ae_rates
barrages11711083barrages
becaps123811403be_cap_s
becarpet1447533becarpet
becarpets1542913becarpets
becrawls1543623becrawls
becrimes1467073becrimes
bedamns1235733bed_amns
bedarken1544513bedarken
bedarkens1643393bedarkens
bedaubs1233693bed_aubs
bedeafen1443343bedeafen
bedeafens1542413bedeafens
bedframe1643023bedframe_
bedimples1642973bedimples
bedirties1275683bedirties
bedlamps1543663bedlamps
bedlams1237053bedla_ms
bedmaker1744933bedmaker
bedmakers1844383bedmakers
bedmate1239433bedmate_
bedpans1237173bedpa_ns
bedplates1445493bedplates
bedraggles1541863bedraggles
bedrail1037253bedra_il
bedraping1535383bedraping
bedrivel1444083bedrivel
bedrivels1542713bedrivels
bedrocks1745333bedrocks
bedrolls1144673bedrolls
bedrooms1345713bedrooms
bedrugs11194283bedr_ugs
bedsides1246533bedsides
bedsores1157633bedsores
bedtimes1336593bedtimes
bedunces1345513bedunces
bedwards1596393bedwards
bedwarfs17113583bedwarfs
begazes1937963be_gazes
begrimes1376513begrimes
behaves15198523be_haves
beldames1336803beldames
beleaped1336103beleaped
beleaps1138053beleap_s
benames112814603be_names
berake124216083be_rake_
beraked144312433be_raked
berate84729023be_rate_
berated104422133be_rated
berdaches1745053berdaches
bereaves1338273bereaves
berimes115216643be_rimes
bermes106023003be_r_mes
berries94423553be_rries
beshames1537203beshames
betakes134212523be_takes
betrayed1436303betrayed
betrayer1345643betrayer
betrayers1445013betrayers
betrays12127823betra_ys
beverages1595223beverages
bewares12313373be_wares
bewrap13157053bewrap__
bewrapped1962513bewrapped
bewrapt14147133bewrap_t
bewrayed1733933bewrayed
bewrayer1643733bewrayer
bewrayers1743483bewrayers
bewrays15145113bewra_ys
boraces113716853b_oraces
borages103917163b_orages
boranes93720403b_oranes
borates94823013b_orates
boraxes163511633b_oraxes
braces108427773b__races
braes75735053b__ra_es
brakes124923123b__rakes
braves115524083b__raves
brazes175522193b__razes
cerates95428253ce_rates
crapes104727693__crapes
degrades11269923degrades
depraves1436873depraves
derates84028893de_rates
drakes114715863__drakes
drape85319633__drape_
draped105314363__draped
draper94315693__draper
drapers105313353__drapers
drapey125010583__drapey
drupes94912653__drupes
enrages83114853_enrages
erases64425403_e_rases
escapes113811673_escapes
etapes85415293_e_tapes
federates13310153federates
ferrates113013423ferrates
grapes95123123__grapes
headraces1546613headraces
herpes115517323he_r_pes
hydrases15227643hydrases
hydrates15229413hydrates
madrases112610003madrases
mediates112814063mediates
peerages1189893peerages
petrales10312983petrales
rapes75740723___rapes
recrates102420373recrates
redates83423873red_ates
redcaps1247073redcap_s
redrafts1235603redrafts
redrawer1235313redrawer
redrawers1344353redrawers
redraws11218473redra_ws
redries83721713redr_ies
redrives122610393redrives
redwares1239053redwares
reframes1338993reframes
regrades103212173regrades
regrates92618403regrates
reshapes1338803reshapes
retapes93917423re_tapes
retraces101417273retraces
rewraps12136563rewrap_s
sarapes94617753_sarapes
scrapes116217663_scrapes
sedates83418043sed_ates
serape84818413se_rape_
seraphs12408093se_raphs
serrates82617023serrates
terraces102712253terraces
terranes82514433terranes
terrases82111483terrases
trapes85024463__trapes
undrape1049333undrape_
undraped1239393undraped

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621507.40619735.6
3Display Results1501500.0602500.0
 (SQL Overall)1786911507.87222699.6
 
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.