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

124 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
beguiled124444(None) 
beguile1056931beguile_
beguiler1154061beguiler
beguiles1146101beguiles
begalled1236022begalled
begrimed1475212begrimed
beguilers1252882beguilers
beguine1068502beguine_
beguines11127212beguines
begulfed1552602begulfed
besmiled1335492besmiled
bewailed1435342bewailed
guiled84315382__guiled
bagpiped1642063bagpiped
bailed94726653b__ailed
becrimed1565513becrimed
becursed1335583becursed
bedeviled1673443bedeviled
bedumbed1643023bedumbed
bedunced1453903bedunced
beelined11277713beelined
beetled1038213be_etled
befooled1434803befooled
befouled1434683befouled
befuddled1742003befuddled
begazed2036203beg_azed
beggared1334753beggared
begged115013813beg__ged
begird1036823beg_i_rd
begirded1334173begirded
begirdled1442403begirdled
beglad10138463beg__lad
begoggled1541713begoggled
begrime1276553begrime_
begrimes1376513begrimes
begrimmed1742543begrimmed
begrudged1562333begrudged
beguiling1334853beguiling
begulf1238903begu_l_f
begulfs1333753begu_lfs
behowled1733473behowled
bejumbled23102043bejumbled
belied95022163be_li_ed
belled94626183be__lled
bellied104314073belli_ed
bemired123410633be_mired
bemixed19337053be_mixed
bemuddled1642313bemuddled
bemused1236713bemu_sed
bemuzzled2262153bemuzzled
benumbed1543193benumbed
berimed124912283be_rimed
berried103714043berri_ed
beslimed1335013beslimed
besmile1137463besmile_
besmiles1237393besmiles
betided114810203be_tided
beuncled1334013beuncled
beveled133811123be_veled
bevelled14327793bevelled
bewailer1334863bewailer
boggled12409003bog_gled
boiled95020953b__oiled
brailed103914013b_railed
broiled103811423b_roiled
bruised10389503b_ruised
bruited104110353b_ruited
bugled104918133b__ugled
build84413353b__uil_d
builded1136473b__uilded
bulled94626493b__ulled
burled94825383b__urled
butled94818603b__utled
ceiled94114953ce__iled
decupled1494983decupled
defiled124013103de_filed
defueled1374513defueled
degummed1542603degummed
degusted1135733degusted
dentiled1039743dentiled
derailed102410403derailed
detailed10319873detailed
deviled124112183de_viled
emailed10359213_emailed
ensiled82611433_ensiled
equaled17166923_equaled
exiled144712463_e_xiled
feruled11318423feru_led
guided94014113__guided
guild75312753__guil_d
guile64521133__guile_
guiles73919283__guiles
guised84612173__guised
gulled84521373__gulled
heiled104415613he__iled
moguled1135933mogu_led
penciled1337823penciled
periled10316323pe_riled
preguided1443923preguided
reboiled11349393reboiled
rebuild1036293rebuil_d
rebuilded1342743rebuilded
recoiled113613213recoiled
refiled114318653re_filed
refueled1286573refueled
regained102111243regained
regaled93615963reg_aled
regild8149773reg_il_d
regilded1135543reg_ilded
remailed112411403remailed
renailed92512803renailed
reoiled84316853re_oiled
required18156833required
requited18169723requited
resailed93613063resailed
resiled84621983re_siled
retailed94113963retailed
retiled84420513re_tiled
reviled114417923re_viled
segued838513segu__ed
sequined18105653sequined
unguided1136233unguided
veiled103714543ve__iled
weeviled1533143weeviled

Search took 8 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.423422437.4
2DLD Change Limit1461621246.61022112.3
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.07925242.4
 
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.