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

105 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
bedel8421940(None) 
bedell93610041bedell
bedels94015271bedels
bedew114513041bedew
betel74419901betel
bevel104517041bevel
bezel165215171bezel
wedel94513961wedel
aedes64625152aedes
babel95821692babel
bade75140882bade_
bagel85116792bagel
beaded104922422beaded
beader94623792beader
beadle93314682beadle
bed67950622bed__
bedded115114072bedded
bedder104215792bedder
bedeck1536212bedeck
bedells10379362bedells
bedevil1344512bedevil
bedews12398942bedews
bedim10313832bedim
beds75937782bed_s
bedu75923692bed_u
bee56262402be_e_
beedi8711662beedi
beef96233682be_ef
been65335782be_en
beep85931212be_ep
beer65635992be_er
bees65453382be_es
beet66457542be_et
befell11428712befell
beget85632562beget
beheld1236412beheld
bel57148462b__el
bell66237182be_ll
belle75827832belle
bended105521232bended
bendee94121022bendee
bender95223302bender
bene66439492bene_
benes75536232benes
beret74946362beret
beryl101211672beryl
beses75830722beses
beset76739132beset
betels84515062betels
bethel1169642bethel
bevels113913982bevels
bezels173712282bezels
bezil163812882bezil
bide76041502bide_
bided95424962bided
bider85728372bider
bides85536772bides
bidet84935622bidet
bode75838752bode_
boded95124962boded
bodes84935102bodes
bordel94514572bordel
botel75121862botel
bowel105621202bowel
brede85520502brede_
bredes94818472bredes
cede74928772cede_
ceded96118562ceded
ceder85322242ceder
cedes84927332cedes
dedal75719022dedal
del46752752__del
devel94217122devel
eel37946842_e_el
fedex1699602fedex
feel75233842fe_el
heder95623642heder
heel75034222he_el
jebel145612142jebel
jewel156711702jewel
keel85729472ke_el
kevel124213102kevel
level84116552level
medal86221332medal
model84521692model
newel86114132newel
pedal86022502pedal
pedes85327292pedes
peel65535612pe_el
rebel73421292rebel
rede55037672rede_
reded74829122reded
redes65139132redes
reel45240532re_el
refel84920812refel
repel74921402repel
revel84423162revel
seder64826762seder
seel45042982se_el
seidel7311082seidel
teel46335802te_el
wedeln10326692wedeln
wedels103811032wedels
weel75834082we_el
yodel94714082yodel

Search took 2 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 Filter178691538000.326548131.9
2DLD Change Limit538001051.48336277.8
3Display Results1051050.0333181.8
 (SQL Overall)1786911051.84297009.2
 
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.