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

152 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
belles8532599(None) 
belies84631051belies
belle75827831belle_
belled94626191belled
bellies94023721bellies
bells76432161bell_s
selles64426981selles
abeles84719392abe_les
bales76250082b_ales
balled94926892balled
baller83825202baller
ballers94421012ballers
ballet84733972ballet
ballets93719512ballets
ballies93725742ballies
balls76236412ball_s
beadles103414732beadles
beagles103212122beagles
bedels94015272bedels
bedless1039702bedless
bees65453382be__es
beetles9312082beetles
beeves114615042beeves
beflea1147122beflea
befleas1236972befleas
beiges91014412beiges
belays114313852belays
belches143514342belches
belgas9311712belgas
belie75630382belie_
belied95022162belied
belief115018602belief
beliefs12448582beliefs
belier84423562belier
beliers94617382beliers
bell66237182bell__
belleek1347242belleek
belleeks1444362belleeks
bellied104314072bellied
bellmen1138142bellmen
bellow114213352bellow
bellows124313302bellows
belly104625492bell_y
belons84119412belons
belows114614182belows
bels66142492be_l_s
belted94020632belted
belter84720962belter
belters93819412belters
beltless10297712beltless
belts75931162be_lts
benes75536232be_nes
bennes86019012bennes
bermes106023002bermes
beses75830722be_ses
betels84515062betels
bevels113913982bevels
bevies114017312bevies
bezels173712282bezels
bibles104617642bibles
biles75542142b_iles
bilges94915632bilges
billed94224902billed
biller84923482biller
billers94720832billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bill_s
birles84920642birles
blues75127042b_lues
bogles95020832bogles
boles75448602b_oles
bolled94722652bolled
bolls75531312boll_s
boules84925972boules
boulles93114122boulles
bugles94822442bugles
bulges95919322bulges
bulled94626492bulled
bullet84528612bullet
bullets93516392bullets
bullies94121892bullies
bulls75629572bull_s
butles84423912butles
celled94420322celled
cellos84517802cellos
cells75428062cell_s
dalles74222062dalles
deles65139252de_les
dellies83622212dellies
dells66630942dell_s
delves104917082delves
ells46431352_ell_s
elves85118742_elves
fellas95116962fellas
felled103720302felled
feller94419552feller
fellers104117542fellers
fellest10313752fellest
fellies104119742fellies
felloes104114382felloes
fells85327382fell_s
filles94224522filles
folles93820472folles
gabelles11278932gabelles
gelees74116262gelees
gelled84718892gelled
helled104024702helled
heller93322512heller
hellers103619832hellers
helloes103717472helloes
hellos95321682hellos
hells85032042hell_s
helves124316062helves
jelled144916062jelled
jellies143816532jellies
jellos134714282jellos
jells125522162jell_s
kellies113516852kellies
melees83618082melees
melled95023022melled
mells75031332mell_s
merles85322762merles
milles84526562milles
nellies73418722nellies
peles75738082pe_les
pellet83326552pellet
pellets94014782pellets
pelves114514662pelves
reales64934122reales
relies65036422relies
rilles64725502rilles
selle54428312selle_
seller63824602seller
sellers73721322sellers
sells55134432sell_s
selves94119612selves
teles54536002te_les
teller63519832teller
tellers73717612tellers
tellies73820512tellies
tells55828942tell_s
tellys9348842tellys
tulles63218892tulles
welled103820212welled
wellies103719072wellies
wells85426192well_s
yelled104116252yelled
yeller94214512yeller
yellers103912952yellers
yells85821942yell_s

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.453394461.4
2DLD Change Limit825511522.71630394.3
3Display Results1521520.0632412.7
 (SQL Overall)1786911523.23255288.1
 
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.