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

155 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
besmiled133550(None) 
besmile1137461besmile_
besmiles1237391besmiles
beguiled1244442beguiled
bemired123410632be_mired
bemixed19337052be_mixed
beslimed1335012beslimed
besmoked17405412besmoked
bewailed1435342bewailed
resailed93613062resailed
resiled84621982res_iled
smiled93716432__smiled
abseiled1144733abseiled
assailed945323assailed
assoiled935023assoiled
bailed94726653b__ailed
basined10310003bas_ined
bastile9313913bastile_
bastiles10313353bastiles
beamed115720733beam__ed
beamier113411943beami_er
beamily1477393beamil_y
becrimed1565513becrimed
bedeviled1673443bedeviled
bedimmed1643443bedimmed
bedimpled1742593bedimpled
beelined11277713beelined
beetled1038223be_etled
befooled1434803befooled
befouled1434683befouled
begalled1236033begalled
begrimed1475213begrimed
beguile1056933beguile_
beguiler1154063beguiler
beguiles1146103beguiles
behowled1733473behowled
bejumbled23102043bejumbled
belied95022163be_li_ed
belled94626193be__lled
bellied104314073belli_ed
bemingled1544083be_mingled
bemire103312803be_mire_
bemires113212833be_mires
bemisted1368383be_misted
bemixes18338653be_mixes
bemused1236713be_mused
bepimpled1842043bepimpled
berimed124912283be_rimed
bermed115217723berm__ed
berried103714043berri_ed
beseemed1334863beseemed
beshamed1635733beshamed
beshiver1634483beshiver
beside95114613bes_ide_
besides104814533bes_ides
besieged1234733besieged
beslaved1435023beslaved
beslime1146833beslime_
beslimes1246953beslimes
besmeared1443433besmeared
besmiling1436263besmiling
besmirch1742133besmirch
besmirched2051933besmirched
besmoke15416623besmoke_
besmokes16406363besmokes
besmudged1642233besmudged
besmutted1442683besmutted
besnowed14124413besnowed
besotted1135843besotted
bested94922763bes__ted
bestirred1243813bestirred
bestowed14156623bestowed
betided114810203be_tided
beuncled1334013beuncled
beveled133811133be_veled
bevelled14327823bevelled
bevomited1742773bevomited
bewailer1334863bewailer
boiled95020953b__oiled
brailed103914013b_railed
brambled15316733brambled
broiled103811423b_roiled
bromized22215903bromized
bumbled144113043b_umbled
busheled1465273busheled
busied95117223bus_i_ed
buskined1534443buskined
bustled104011523bus_tled
ceiled94114953ce__iled
defiled124013103de_filed
demised113613683de_mised
dentiled1039743dentiled
derailed102410403derailed
desired9311983des_ired
desmid1048363desmi__d
despised1236923despised
despited1248323despited
despoiled1344653despoiled
destined103312453destined
detailed10319873detailed
deviled124112183de_viled
emailed10359213_emailed
ensiled82611433_ensiled
ermined10410603_ermined
espied9359773_espi_ed
exiled144712463_e_xiled
heiled104415613he__iled
jemmied19294483jemmi_ed
misfiled14278653misfiled
nestled8349913nes_tled
outsmiled1245673outsmiled
penciled1337823penciled
periled10316323pe_riled
pestled102711453pes_tled
reboiled11349393reboiled
recoiled113613213recoiled
refiled114318653re_filed
remailed112411403remailed
remised103516843re_mised
remixed173510743re_mixed
renailed92512803renailed
reoiled84316853re_oiled
resampled1454113resampled
rescaled113311303rescaled
resealed92713973resealed
reseized1839213reseized
resembled1445173resembled
reshined123011123reshined
resided95217703res_ided
resile64627673res_ile_
resiles74026543res_iles
resined84522653res_ined
resited85122423res_ited
resized174614903res_ized
resmelted1236043resmelted
resoled84119283res_oled
respired1148993respired
respited11410813respited
restyled1236953restyled
retailed94113963retailed
retiled84420513re_tiled
reviled114417923re_viled
sailed74327763__sailed
sessile739523sessile_
smile74823923__smile_
smiler83916683__smiler
smiles84522293__smiles
smiley114012303__smiley
soiled73822473__soiled
spiled94621993__spiled
templed12278563te_mpled
unsoiled92412083unsoiled
veiled103714543ve__iled
vesseled1243833vesseled
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.420425454.8
2DLD Change Limit1461621557.08020644.4
3Display Results1551550.0602583.3
 (SQL Overall)1786911557.56023636.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.