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

188 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
widowed153484(None) 
widower1435341widower
windowed1635571windowed
dowed104632612__dowed
endowed1248172endowed
indowed1237442indowed
miaowed1333882miaowed
widdled133511232widdled
widened12328052widened
widow1278932widow__
widowered1742752widowered
widowers1535112widowers
widows1376562widow_s
willowed15156762willowed
windrowed1743712windrowed
winnowed1543472winnowed
wowed124023772w__owed
adored84714243_adored
aided75828933aid__ed
allowed111610083allowed
arrowed1148113arrowed
avowed1335963_avowed
bedewed1437153bedewed
bided95424963bid__ed
bigoted11258403bigoted
billowed14137063billowed
bilobed1235913bilobed
blowed125016693_blowed
bowed114533423__bowed
browed125216393_browed
chowed154914653_chowed
cowed115637853__cowed
crowed124717303_crowed
dadoed9449903dado_ed
dawed106222813__dawed
dewed105020303__dewed
diddled114212053diddled
didoes85716963dido_es
disowned1336433disowned
doled75430913__doled
domed95423263__domed
doped95326713__doped
dosed76626913__dosed
doted75227073__doted
dowel95618193__dowel
dower95027703__dower
downed115314783__downed
dowsed115015013__dowsed
dozed165619353__dozed
elbowed13235473elbowed
embowed15236903embowed
endower1138483endower
fiddled13329633fiddled
fidged124610933fid_ged
flowed133513763_flowed
giddied11257713giddied
glowed114913833_glowed
hided105222443hid__ed
idled74915213_id_led
ironed74916013_ironed
jowed164724423__jowed
kidded13299393kid_ded
kotowed1533773kotowed
lidded93410243lid_ded
lowed95233903__lowed
meowed12148003_meowed
miaoued1034583miaoued
middled123311903middled
mildewed1543763mildewed
minored10310103minored
mowed113629013__mowed
nidated939863nidated
nided75920873nid__ed
odored8399223_odored
owed86833873___owed
picoted1239213picoted
piddled123311253piddled
pillowed14156383pillowed
piloted10310323piloted
pivoted1336513pivoted
plowed124213203_plowed
resowed113712253resowed
ridded93615123rid_ded
riddled103012043riddled
ridged94014223rid_ged
rioted73416373ri_oted
rowed94034323__rowed
scowed124413833_scowed
shadowed1644473shadowed
showed135016973_showed
sided74825953sid__ed
sidled84215173sid_led
siloed74615303silo_ed
sinewed1137053sinewed
skidooed1442623skidooed
slowed104617073_slowed
snowed104613623_snowed
sowed94933863__sowed
stowed105817203_stowed
strowed115312143strowed
tided76322513tid__ed
tidied83613273tid_ied
towed95134583__towed
trowed104714653_trowed
twiddled14284633twiddled
unbowed132610243unbowed
unsowed112511053unsowed
viewed1345993vi_ewed
visored1138143visored
vizored2034133vizored
vowed124424573__vowed
wadded124014173wad_ded
waddied13358563waddied
waddled133611643waddled
waded106024753wad__ed
wagoned1256223wagoned
wallowed15148163wallowed
wedded123811843wed_ded
wedeled1237783wedeled
wedged125110303wed_ged
whidded1634423whid_ded
whoofed17374513whoofed
whooped16326933whooped
whored135512123w_hored
wicked164317413wi_cked
widder112913973wid_der
widdie113410733widdie_
widdies123514033widdies
widdle113814843widdle_
widdles123514343widdles
wide85235413wid__e_
widen94717973wid__en
widener11318693widener
wider94826353wid__er
wides94832823wid__es
widget113815263wid_get
widowbird1951213widowbird
widowhood2052103widowhood
widowing1635183widowing
wielded12216683wielded
wifed125117743wi__fed
wigged124413583wi_gged
wiggled13299603wiggled
wilded113714503wi_lded
wildered1336633wildered
wildwood1643593wildwood
wiled95231553wi__led
willed104722453wi_lled
willied114611563willied
willower14127453willower
wilted103915713wi_lted
wimbled15298153wimbled
wimped144211513wi_mped
wimpled15338823wimpled
winced124415343wi_nced
winched163110593winched
winded114918213wi_nded
windled123713483windled
window1347363window__
windows1447743window_s
windowy1744643window_y
windrower1644223windrower
wined94434183wi__ned
winged114620833wi_nged
winked144018603wi_nked
winkled15299593winkled
winned104017013wi_nned
winnower1444253winnower
winoes94317013wino_es
wintled11339843wintled
wiped114722083wi__ped
wired95327643wi__red
wised95123343wi__sed
wished134417513wi_shed
wisped123411893wi_sped
wissed104114643wi_ssed
wisted104120273wi_sted
witched163012193witched
wited94727143wi__ted
withed134416233wi_thed
witted104216813wi_tted
wived125121503wi__ved
wizened20275423wizened
wooded114213683w_ooded
wooed94419873w__ooed
woofed134511203w_oofed
wooled103715503w_ooled
yowed1253025183__yowed

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 Filter1786911340270.453394461.4
2DLD Change Limit1340271886.33021173.3
3Display Results1881880.0632984.1
 (SQL Overall)1786911886.84626101.5
 
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.