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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
belied9502216(None) 
belie75630381belie_
belief115018601belief
belier84423561belier
belies84631051belies
belled94626181belled
bellied104314071bellied
belted94020631belted
relied74926231relied
aeried74221862aeried
allied74217152allied
babied114913512babied
bailed94726652bailed
balded105417512balded
baled85436442bal_ed
balked135219412balked
balled94926892balled
beaded104922422beaded
beaked135919492beaked
beamed115720732beamed
beaned95621472beaned
becked155417762becked
bedded115114062bedded
beefed123510872beefed
beelined11277712beelined
beeped115313452beeped
begged115013802begged
begird1036822begird
behind1238062behind
belaced124112152belaced
beladied1236662beladied
belated103520012belated
belaud939132belaud
belayed133610082belayed
belched154011842belched
belfried1444202belfried
beliefs12448582beliefs
beliers94617382beliers
believe12519772believe
believed14427922believed
belike124616282belike
belive115415302belive
belle75827832belle_
belles85325992belles
bellies94023722bellies
beloved13188392beloved
belter84720962belter
bemired123410632bemired
bemixed19337052bemixed
bended105521232bended
berimed124912282berimed
bermed115217722bermed
berried103714042berried
beside95114612beside
beslimed1335012beslimed
bested94922752bested
betide95115972betide
betided114810202betided
betted94721162betted
bevies114017302bevies
bielded11226712bielded
bilged105513182bilged
bilked134012942bilked
billed94224902billed
bled75729312b_l_ed
bleed85019802b_leed
blind86319322b_lind
blued84520322b_lued
bodied103814582bodied
boiled95020952boiled
bolide9515562bolide
bolled94722652bolled
bolted94617802bolted
bulbed114312772bulbed
bulged105117122bulged
bulked134216742bulked
bulled94626492bulled
bullied104514812bullied
buried94822372buried
busied95117222busied
bylined1335852bylined
ceiled94114952ceiled
celled94420322celled
defied115016382defied
deled75326542del_ed
delimed11310722delimed
delved114112752delved
denied84318632denied
eelier64216462eelier
elide64922642_elide
elided84814672_elided
felid94717172feli_d
felled103720302felled
felted103714652felted
flied96519432_flied
gelded94512112gelded
gelid74916972geli_d
gelled84718892gelled
heiled104415612heiled
helled104024702helled
helmed124513692helmed
helped124714152helped
helved134313702helved
jelled144916062jelled
jellied15419222jellied
kelped13449542kelped
levied104111432levied
lied55838092__lied
lilied73913212lilied
melded104714712melded
melled95023022melled
melted94219062melted
obelised1136172obelised
obelized2036332obelized
pelted94617752pelted
plied85118592_plied
relief94419682relief
relier65826182relier
relies65036422relies
relined85321932relined
relived115114682relived
replied103914442replied
retied75924982retied
selfed10310912selfed
veiled103714542veiled
welded114013382welded
welled103820212welled
welted103715822welted
yelled104116252yelled
yelped12439362yelped

Search took 3 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 Filter178691825510.1231452772.4
2DLD Change Limit825511302.61031628.7
3Display Results1301300.0304333.3
 (SQL Overall)1786911302.76364672.8
 
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.