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

103 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
beholder143505(None) 
beholden1443591beholden
beholders1544931beholders
beheader1436042beheader
behold1247342behold__
beholds1336422behold_s
bewilder1434132bewilder
bolder94820932b__older
coholder1436072coholder
holder104619652__holder
inholder1276112inholder
penholder1544412penholder
pewholder1842722pewholder
resolder9259232resolder
upholder1444082upholder
balder95318863b__alder
beader94623793be__ader
bebopper1642103bebopper
bedder104215793be__dder
beetler938033beetl_er
beflower16166273beflower
befouler1343923befouler
behalves1644083behalves
behaver15206723beh_aver
beheaded1536373beheaded
beheaders1545153beheaders
beheld1236413beheld__
beholding1634233beholding
behoove1553773behoove_
behooved1743133behooved
behooves1653793behooves
behove14207203beho_ve_
behoved16205563beho_ved
behoves15177353beho_ves
behowled1733473behowled
belier84423563be__lier
bellower13159063bellower
belter84720963be__lter
bender95223303be__nder
beveler124010683bevel_er
beveller13387663beveller
bewilders1543813bewilders
blonder104011943b_londer
bolter83920753b__olter
bonder95324783b__onder
bondholder1753093bondholder
boodler103312003b_oodler
border94419973b__order
boulder103411343b_oulder
bowlder13407483b_owlder
broader103412613b_roader
broider103912973b_roider
brooder103811623b_rooder
builder1037573b_uilder
choler113717153_chol_er
chowder16387813_chowder
coholders1535623coholders
colder95121853__colder
decoder113712293deco_der
dehorner1235523dehorner
elder64020023_e__lder
enfolder1286153enfolder
evolver13275803_evolver
folder104317543__folder
freeholder1753103freeholder
gasholder1443823gasholder
gelder84613713ge__lder
golder84417603__golder
holden104113953__holden
holders113715903__holders
holier94921623__holier
holler93520613__holler
infolder1256433infolder
inholders1345353inholders
jobholder2242243jobholder
melder93915813me__lder
molder93819273__molder
older65121173___older
penholders1643793penholders
pewholders1942703pewholders
polder94019253__polder
potholder1544763potholder
recorder11249633recorder
refolded1337063refolded
reloader937913reloader
remolded1237403remolded
reorder8239483re_order
reroller8258753reroller
resolders10258013resolders
resolver11339793resolver
revolter11279363revolter
revolver14287713revolver
scolder103210343_scolder
seconder1137183seconder
shoulder1234753_shoulder
smolder10327753_smolder
solder73921343__solder
unbeholden1651463unbeholden
unfolder12216583unfolder
unholier1137283unholier
unsolder937213unsolder
upholders1543643upholders
welder102914413we__lder

Search took 7 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.406440125.6
2DLD Change Limit1461621036.39022873.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.84226116.8
 
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.