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

151 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
bedotted123498(None) 
besotted1135841besotted
befitted14305722befitted
begotten1143242begotten
beknotted1642352beknotted
betted94721162be__tted
blotted103911832b_lotted
dotted84717522__dotted
repotted1139282repotted
undotted1048522undotted
abetted1058323abe__tted
adopted1136253_adopted
allotted986873allotted
batted95623653b__atted
beclothed1744123beclothed
bedamned1434583bedamned
bedaubed1443183bedaubed
bedded115114073bed__ded
bedecked1874573bedecked
bedewed1437153bed_ewed
bedighted1744583bedighted
bedimmed1643443bedimmed
bedirtied1393733bedirtied
bedmate1239433bedmate_
bedmates1349183bedmates
bedraped1455813bedraped
bedroomed1543643bedroomed
bedstand1244333bedstand
bedstead1253403bedstead
bedumbed1643023bedumbed
bedunced1453903bedunced
bedwetter1542663bedwetter
beetled1038213be_etled
befogged1643153befogged
befooled1434803befooled
befouled1434683befouled
befretted1544373befretted
begetter11136313begetter
behooved1743133behooved
behoved16205563beho_ved
behowled1733473behowled
belated103520013be_lated
belittled1243033belittled
belonged1235313belonged
beloved13188393belo_ved
belted94020633be__lted
bemisted1368383bemisted
bemoaned1335553bemoaned
bemocked1934073bemocked
berated104422133be_rated
berobed1238233bero_bed
berouged1235323berouged
berthed13259123be_rthed
besetter10137973besetter
beshouted1544073beshouted
besmutted1442683besmutted
besoothed1543663besoothed
bested94922753be__sted
bestowed14156613bestowed
betatter1035453betatter
betrothed1544943betrothed
better84723703be__tter
bevomited1742773bevomited
bewormed16235443bewormed
bigoted11258403bigo_ted
bitted94418483b__itted
blatted104812713b_latted
bloated104513433b_loated
blotter94612853b_lotter
boated94221973b__oated
bolted94617803b__olted
boosted104111983b_oosted
booted94822733b__ooted
bottled104611233b__ottled
boycotted1742033boycotted
brevetted1543863brevetted
budgeted1344883budgeted
butted94722063b__utted
clotted104011823_clotted
decocted1437683decocted
deducted1356243deducted
defatted1335673defatted
dehorted1357303dehorted
demitted12288773demitted
demoted114313543demo_ted
denoted93512763deno_ted
deported1249703deported
deratted1048403deratted
devoted124111093devo_ted
doated84118183__doated
doited85016633__doited
doted75227073__do_ted
dottel73610893__dottel
dotter74419343__dotter
edited83913673_ed_ited
emitted103010853_emitted
emoted94614923_emo_ted
fetted104817893fe__tted
garotted1066193garotted
gavotted1363343gavotted
hotted104319943__hotted
jetted143915083je__tted
jotted143615173__jotted
knotted12357233_knotted
letted74118543le__tted
lotted74222403__lotted
mediated123011873mediated
meditated1348083meditated
netted74118713ne__tted
petted94121523pe__tted
plotted104612373_plotted
potted94624013__potted
readopted1344913readopted
rebooted11248463rebooted
rebottled1243433rebottled
rebutted11126783rebutted
recoated113416783recoated
redacted12410243redacted
redated93120923red_ated
redocked16206823redocked
redonned10297103redonned
refitted12309413refitted
reknotted1443523reknotted
remitted113312073remitted
replotted1235823replotted
reported11312703reported
rerouted9311143rerouted
resorted9313493resorted
respotted1235953respotted
retorted9312333retorted
retted74826313re__tted
revetted122210943revetted
revolted12319863revolted
revoted114314153revo_ted
rewetted12228353rewetted
rotted74524433__rotted
sedated93714353sed_ated
shotted113912403_shotted
slotted84613883_slotted
sotted74121403__sotted
spotted103713143_spotted
stotted83511423_stotted
swotted11398713_swotted
totted74319953__totted
trotted83711283_trotted
unpotted11108393unpotted
vedette1166003vedette_
vedettes1265943vedettes
vetted104316323ve__tted
wetted103717023we__tted
wotted104115713__wotted

Search took 9 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 Limit1461621517.70618967.3
3Display Results1511510.0602516.7
 (SQL Overall)1786911518.18621828.9
 
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.