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

141 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
becursed133559(None) 
becurse1136181becurse_
becurses1236721becurses
accursed1354642accursed
becrusted1443952becrusted
becurst1147852becurs_t
bemused1236712bemu_sed
cursed94321252__cursed
decurved1534842decurved
recurred1137092recurred
recurved1436492recurved
recused104714432recu_sed
secured1059722secur_ed
uncursed1148972uncursed
accused12368433accu_sed
bearded114212133be_arded
becalmed1534813becalmed
becapped1733943becapped
becarpet1447533becarpet
because1136233because_
becharmed1944663becharmed
becked155417763bec__ked
beckoned1735793beckoned
beclasped1643753beclasped
becrimed1565523becrimed
becrowd1555183bec_rowd
becrust1137983becrus_t
becrusts1244843becrusts
becudgel1452163becudgel
becursing1435453becursing
bedumbed1643023bedumbed
bedunced1453903bedunced
begirded1334173begirded
beguiled1244443beguiled
begulfed1552603begulfed
bekissed1543163bekissed
belfried1444203belfried
bemired123410633bemir_ed
bemuse1038943bemu_se_
bemuses1139293bemu_ses
benumbed1543193benumbed
bermed115217723be__rmed
berried103714053be_rried
bescoured1444333bescour_ed
bewared13310113bewar_ed
bewormed16235443bewormed
bloused104310643blou_sed
blurbed12337613b_lurbed
blurred10427803b_lurred
blurted10399783b_lurted
bourse84414333b_ourse_
bourses94014303b_ourses
boused95322883b_ou_sed
bruised10389503b_ruised
buried94822373b__uried
burked135220883b__urked
burled94825383b__urled
burned95818963b__urned
burped116215503b__urped
burred95820723b__urred
burse75527253b__urse_
burseed1049503b__urseed
burses84425513b__urses
bursted1039423b__ursted
bused85624493b__u_sed
bussed94717053b__ussed
coursed104113603_coursed
curbed114615873__curbed
curded104217163__curded
cured85932133__cur_ed
curled95021653__curled
curred94319263__curred
curse75829143__curse_
curser84721473__curser
curses85328273__curses
curved124815223__curved
cussed94917123__cussed
deceased1247723deceased
decerned1237263decerned
decreed112710263dec_reed
decried112612863dec_ried
decupled1494993decupled
decuries11312223decuries
decurve1335583decurve_
decurves1435863decurves
defused125211093defu_sed
demurred1234933demurred
emersed10138513_emersed
enured73315333_enur_ed
evulsed1133963_evulsed
excused1736293excu_sed
focused13166413focu_sed
focussed14174043focussed
hearsed113811423he_arsed
hocused13167013hocu_sed
hocussed14153793hocussed
incurred1136493incurred
incurved1435313incurved
incused102911173incu_sed
lectured11127233lectur_ed
necrosed1137223necrosed
nursed74514673__nursed
obscured1343893obscur_ed
occurred1343483occurred
outcursed1245133outcursed
percussed1444813percussed
perused103112203peru_sed
precured1339993precur_ed
pursed95220883__pursed
reburied1137913reburied
recessed1139723recessed
recorded122511073recorded
recorked15239863recorked
recourse1038383recourse_
recourses1137733recourses
recurs83315803recurs__
recurve1237403recurve_
recurves1337403recurves
recuse85519163recu_se_
recuses94619463recu_ses
refused115114443refu_sed
repulsed1136563repulsed
repursued1243013repursued
resurged1038623resurged
returned9459133returned
reused75419563re_u_sed
reversed122711613reversed
revulsed1235443revulsed
secerned1136103secerned
secure8513533secur_e_
securer958253secur_er
secures9613163secur_es
securest1058583securest
tenured838363tenur_ed
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
upcurled1393783upcurled
upcurved16142993upcurved
velured1136683velur_ed
versed104515523ve__rsed

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.453394461.4
2DLD Change Limit1461621416.95321021.4
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.45223978.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.