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

163 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
bedrape127769(None) 
bedraped1455811bedraped
bedrapes1386961bedrapes
bedframe1643022bedframe
bediaper1344932bediaper
bedmate1239432bedmate
bedrail1037252bedrail
berake124216082be_rake
berate84729022be_rate
bewrap13157052bewrap_
bewraps14135402bewraps
bewrapt14147132bewrapt
drape85319632__drape
serape84818412se_rape
undrape1049332undrape
aerate64830553ae_rate
barrage10710843barrage
bearable121512363bearable
became123213163be_came
becap114315053be_cap_
becaps123811403be_caps
becarpet1447533becarpet
becrawl1444583becrawl
becrime1387053becrime
bedamn1137813bed_amn
bedarken1544513bedarken
bedaub1146033bed_aub
beddable14166923beddable
bedeafen1443343bedeafen
bedfast1346413bedfast
bedframes1743013bedframes
bediapers1444323bediapers
bedimple1543133bedimple
bedlam1149273bedla_m
bedlamp1464513bedlamp
bedlamps1543663bedlamps
bedlams1237053bedlams
bedlike14369533bedlike
bedmaker1744933bedmaker
bedmates1349183bedmates
bedpan1137583bedpa_n
bedpans1237173bedpans
bedplate1346223bedplate
bedraggle1442123bedraggle
bedrails1136293bedrails
bedraping1535373bedraping
bedrid1039943bedr_id
bedrivel1444083bedrivel
bedrock1645643bedrock
bedroll1055553bedroll
bedroom1247083bedroom
bedrug10164953bedr_ug
bedrugs11194283bedrugs
bedside1156843bedside
bedsore1057803bedsore
bedtime1236973bedtime
bedunce1235683bedunce
bedward1497473bedward
bedwarf16106463bedwarf
begaze1838333be_gaze
begrime1276553begrime
behave14209013be_have
beldame1237233beldame
beleap10410283beleap_
beleaped1336103beleaped
beleaps1138053beleaps
beleapt11310253beleapt
bename103316073be_name
beraked144312433be_raked
berakes134815773be_rakes
berated104422133be_rated
berates94126853be_rates
berdache1644033berdache
bereave1258353bereave
berime105317333be_rime
berme96022943be_r_me
beshame1447483beshame
bespake15436963bespake
betake124512703be_take
betray111511443betra_y
betrayed1436303betrayed
betrayer1345643betrayer
betrays12127823betrays
beverage1445143beverage
beware11313713be_ware
bewrapped1962513bewrapped
bewray14147733bewra_y
bewrayed1733933bewrayed
bewrayer1643733bewrayer
bewrays15145113bewrays
borage93917013b_orage
borane84620213b_orane
borate85026153b_orate
brace95629273b__race
brae65639113b__ra_e
brake116025343b__rake
brave104925503b__rave
braze165423453b__raze
cerate84829463ce_rate
crape96128443__crape
degrade10229903degrade
deprave1337073deprave
derate74531233de_rate
drake104918303__drake
draped105314363__draped
draper94315693__draper
drapes95419653__drapes
drapey125010583__drapey
drave95219273__drave
drupe85012993__drupe
enrage72715073_enrage
enrapt8313013_enrapt
erase54925493_e_rase
escape103811663_escape
etape74413703_e_tape
exedrae1544713exedra_e
federate12310873federate
ferrate103014033ferrate
grape84824663__grape
headrace1446663headrace
hydrae13258573hydra_e
hydrase14287663hydrase
hydrate14239813hydrate
mediae94217413media_e
mediate103415213mediate
pedate93117763ped_ate
peerage1089803peerage
petrale9312623petrale
rape65041633___rape
recrate92621643recrate
redate74124683red_ate
redcap1158493redcap_
redcaps1247073redcaps
rediae74221993redia_e
redraft11310573redraft
redraw10269853redra_w
redrawer1235313redrawer
redrawn11245953redrawn
redraws11218473redraws
redrive112410563redrive
redrove11249423redrove
redware1139353redware
reframe1239393reframe
regrade92612033regrade
regrate82618653regrate
reshape1249043reshape
retape83917683re_tape
retrace91417343retrace
rewrap11127533rewrap_
rewraps12136563rewraps
rewrapt12138113rewrapt
sarape84817573_sarape
scrape105917573_scrape
sedate73019803sed_ate
serapes95218103se_rapes
seraph114011163se_raph
serrate73017533serrate
teraph11319093te_raph
terrace93311833terrace
terrae62915203terra_e
terrane72814223terrane
undraped1239393undraped
undrapes1138603undrapes

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271635.89022755.0
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.10929250.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.