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

161 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
belies8463105(None) 
belie75630381belie_
belied95022161belied
belief115018601belief
beliefs12448581beliefs
belier84423561belier
beliers94617381beliers
belles85325991belles
bellies94023721bellies
bevies114017301bevies
relies65036421relies
abeles84719392abel_es
abelias93213562abelias
aeries64737782aeries
allies63827672allies
babies106123652babies
bailies94120202bailies
baldies105317702baldies
bales76250082bal_es
ballies93725742ballies
beanies93821092beanies
bedims1149592bedims
beedies10314202beedies
beelines103312802beelines
bees65453382be__es
beeves114615042beeves
befits114711502befits
begins94415302begins
beiges91014402beiges
bekiss1236372bekiss
beladies11310422beladies
belays114313852belays
belches143514342belches
belfries1336982belfries
belgas9311712belgas
believe12519772believe
believes13449402believes
belike124616282belike
belive115415302belive
belle75827832belle_
belled94626182belled
bellied104314072bellied
bells76432162bel_ls
belons84119412belons
belows114614182belows
bels66142492bel__s
belted94020632belted
belter84720962belter
belters93819412belters
belts75931162bel_ts
bemires113212832bemires
bemixes18338652bemixes
benes75536232be_nes
bennes86019012bennes
bennies93917312bennies
berimes115216642berimes
berlines102315452berlines
berlins93216012berlins
bermes106023002bermes
berries94423552berries
beses75830722be_ses
besides104814532besides
beslimes1246952beslimes
betides104915262betides
betimes115114412betimes
betise85616272betise
betises94816122betises
bewigs1246532bewigs
beylics1436182beylics
beyliks1634852beyliks
bezils1711310602bezils
bialies93618412bialies
bikies124515162bikies
bilbies114712342bilbies
biles75542142bil_es
bilges94915632bilges
billies93923502billies
blips95615782b_lips
bliss75616912b_liss
blites84721212b_lites
blues75127042b_lues
bodies94524142bodies
bogies94724312bogies
boles75448602bol_es
bolides10515072bolides
bries74942152b_ries
bulges95919322bulges
bullies94121892bullies
buries84633272buries
busies85525262busies
bylines1239242bylines
colies84837052colies
defies104624052defies
deles65139252del_es
delimes10314192delimes
delis64928542deli_s
dellies83622212dellies
delves104917082delves
demies94825802demies
denies74729642denies
dexies145018342dexies
eelier64216462eelier
eeliest73516472eeliest
elides74420692_elides
elites66027122_elites
elves85118742_elves
felids103111622felids
felines104718072felines
fellies104119742fellies
ferlies103216692ferlies
flies85630712_flies
gelees74116262gelees
genies75324942genies
helices12313722helices
helios94816632helios
helixes1739132helixes
helves124316062helves
holies94630032holies
jellies143816532jellies
kelims1278912kelims
kellies113516852kellies
kelpies13289902kelpies
levies93919862levies
lies46454192__lies
lilies63021412lilies
mealies92821932mealies
melees83618082melees
molies84429512molies
nellies73418722nellies
newies91014072newies
obelias9279032obelias
obelise9310172obelise
obelises1039102obelises
obelizes1937512obelizes
peles75738082pel_es
pelites93821992pelites
pelves114514662pelves
plies74526512_plies
polies84034582polies
reflies104418532reflies
relics84517902relics
relied74926232relied
relief94419682relief
reliefs10439432reliefs
relier65826182relier
reliers75519212reliers
relines75331322relines
relives104619442relives
replies94521042replies
reties65436192reties
selkies113513352selkies
selles64426982selles
selves94119612selves
series64540972series
teles54536002tel_es
tellies73820502tellies
uglies7412322uglies
vegies104314272vegies
velites103417302velites
walies95324522walies
wellies103719072wellies

Search took 4 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.1061685764.2
2DLD Change Limit825511613.11026543.7
3Display Results1611610.0632555.6
 (SQL Overall)1786911613.27954495.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.