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

370 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
wielded1221668(None) 
bielded11226711bielded
fielded12206811fielded
welded114013381w_elded
wielder11197671wielder
wilded113714501wi_lded
yielded12184711yielded
fielder11217412fielder
gelded94512112_gelded
gilded94413222gi_lded
melded104714712_melded
milded104416152mi_lded
shielded1334392shielded
wedded123811832w_edded
weeded113914872w_eeded
weirded1234512weirded
welder102914412w_elder
welled103820212w_elled
welted103715822w_elted
wended113616152w_ended
whelmed16375152whelmed
whelped16355632whelped
widdled133511232widdled
wield95213912wiel__d
wielders12196612wielders
wieldier1234282wieldier
wields10469622wield_s
wieldy13476182wield_y
wilder103616472wi_lder
wiled95231552wi_l_ed
willed104722452wi_lled
willied114611562willied
wilted103915712wi_lted
winded114918212wi_nded
windled123713482windled
yielder11175112yielder
aided75828933ai__ded
ailed66240283ai_l_ed
aisled74516183aisl_ed
amended11328313amended
aneled74719273anel_ed
balded105417513_balded
beaded104922423_beaded
bedded115114063_bedded
belied95022163_belied
belled94626183_belled
belted94020633_belted
bended105521233_bended
bided95424963bi__ded
bield84614653biel__d
bields94110003bield_s
bilged105513183bi_lged
bilked134012943bi_lked
billed94224903bi_lled
birded104414303bi_rded
birled94416993birl_ed
blended114710713blended
breaded115014063breaded
builded1136473builded
ceded96118553_ce_ded
ceiled94114953ceil_ed
celled94420323_celled
deeded94615543_deeded
deled75326543_del_ed
deluded10158763_deluded
delved114112753_delved
dialed84716453dial_ed
dialled9510133dialled
diddled114212053diddled
dieted83115493die_ted
dilled84122223di_lled
dindled104412723dindled
dirled84514903dirl_ed
divided13378593divided
dreaded103612023dreaded
dueled84813663duel_ed
duelled9359753duelled
dwelled12337593dwelled
dwindled14385023dwindled
elder64020023__elder
elided84814673__elided
eluded84612773__eluded
emended11329603emended
ended74421263__ended
felled103720303_felled
felted103714653_felted
fended114216913_fended
feuded114010003_feuded
fiddled13329633fiddled
field95015323fiel__d
fielders12156773fielders
fields104211043field_s
filed95331903fi_l_ed
fileted1159093fileted
filled104922263fi_lled
filmed124610363fi_lmed
folded114212793_folded
friended1335033friended
fueled104913603fuel_ed
fuelled11369193fuelled
gelder84613713_gelder
gelled84718893_gelled
gilder84415533gi_lder
gilled84521633gi_lled
gillied95512313gillied
girded93712493gi_rded
girdled10217453girdled
headed114020473_headed
heeded114215763_heeded
heeled104018413heel_ed
heiled104415613heil_ed
helled104024703_helled
helmed124513693_helmed
helped124714153_helped
helved134313703_helved
herded114215643_herded
hided105222443hi__ded
hilled104022223hi_lled
hilloed113211293hilloed
hilted104016043hi_lted
idled74915213_idl_ed
illuded9305763_illuded
isled64615993_isl_ed
jelled144916063_jelled
jilted144111353ji_lted
keeled114414263keel_ed
kelped13449543_kelped
kidded13299383ki_dded
killdee1266213killdee
killed113918773ki_lled
kilned11368393ki_lned
kilted113613833ki_lted
kindled133410543kindled
kneaded13146473kneaded
knelled12338983knelled
kvelled15276063kvelled
leaded84221543_leaded
libeled10249413libel_ed
libelled11317213libelled
lidded93410243li_dded
lieder74912323lie_der
lilied73913213li_lied
lilted73715373li_lted
melder93915813_melder
melled95023023_melled
melted94219063_melted
mended104418683_mended
middled123311903middled
milden94113153mi_lden
milder93818453mi_lder
mildew12319043mi_ldew
milked134612573mi_lked
milled94326173mi_lled
milted93919943mi_lted
minded103817833mi_nded
misled94719313misl_ed
molded104414083_molded
moulded11348063moulded
needed84114443_needed
needled9358513needled
nided75920873ni__ded
nielloed963863nielloed
nilled73919453ni_lled
oiled64429473oi_l_ed
peeled94119703peel_ed
pelted94617753_pelted
pended103819013_pended
piddled123311253piddled
pieced113912103pie_ced
pierced12347593pierced
piled85232993pi_l_ed
pilled94222753pi_lled
pleaded113511263pleaded
preluded1236453preluded
quelled17279273quelled
redded94019543_redded
reded74829113_re_ded
reeded84022563_reeded
reeled74725533reel_ed
relied74926233_relied
rended84524103_rended
rewelded1335893rewelded
ridded93615123ri_dded
riddled103012043riddled
rifled104115003rifl_ed
riled65833253ri_l_ed
rilled74525653ri_lled
rinded84418983ri_nded
scalded11409763scalded
scended11329873scended
scolded11358853scolded
seeded84520463_seeded
seeled73922093seel_ed
selfed10310913_selfed
sended85121233_sended
shedded13419063shedded
shelled113815083shelled
shelved14379933shelved
shielder1235183shielder
sided74825953si__ded
sidled84215173sidl_ed
sieged85212713sie_ged
sieved104611443sie_ved
silked114314813si_lked
siloed74615303si_loed
silted74020013si_lted
skelped1435203skelped
sledded10378873sledded
smelled103511853smelled
smelted10399093smelted
snedded10377393snedded
snelled83313043snelled
speeded113310423speeded
spelled103714733spelled
spieled104811883spiel_ed
steaded92811673steaded
sueded84014633sue_ded
swelled113211693swelled
swilled113611833swi_lled
swindled13307623swindled
swirled11308223swirl_ed
swiveled1544163swivel_ed
swivelled1662963swivelled
tedded93810893_tedded
tended83819483_tended
tided76322513ti__ded
tierced10347053tierced
tiered73613973tie_red
tilde65017343ti_lde_
tildes74513963ti_ldes
tiled64832943ti_l_ed
tilled74722953ti_lled
tilted74616863ti_lted
tirled74714363tirl_ed
titled73815003titl_ed
treaded95014283treaded
trended94011763trended
tweedled1332833tweedled
twiddled14284633twiddled
twilled11398033twi_lled
twirled11385983twirl_ed
unended92811823unended
ungelded1147403ungelded
unwelded1337133unwelded
upended11267323upended
veiled103714543veil_ed
vended114416353_vended
vialed105112593vial_ed
vialled1156843vialled
viewed1345993vie_wed
wadded124014173w_added
waddled133611643waddled
waded106024753w__aded
wailed104823593wail_ed
waled94330993w_al_ed
walked145313783w_alked
walled104021293w_alled
warded115021043w_arded
wauled104713963waul_ed
wawled133811703wawl_ed
weaned103816153w_eaned
weaved133913483w_eaved
webbed1436433w_ebbed
webfed1535033w_ebfed
wedder113612293w_edder
wedel94513953w_e_del
wedeled1237783wedel_ed
wedged125110273w_edged
weed85637513w_e__ed
weeder103315513w_eeder
weened104013733w_eened
weeted103913793w_eeted
weeweed1435183weeweed
weighed15135933weighed
weirder1144923weirder
welched16298833w_elched
weld84727733w_el__d
welders113313413w_elders
weldor10317653w_eldor
welds94719163w_eld_s
welshed14277203w_elshed
welter93417383w_elter
wetted103717023w_etted
whaled134612033whal_ed
wheedled1633033wheedled
wheeled14318463wheeled
wheeped16387503wheeped
wheezed23296453wheezed
whetted14256693whetted
whidded1634423whidded
whiled134514133whil_ed
whirled14368043whirl_ed
wicked164317413wi_cked
widder112913973wi_dder
widdle113814843widdle_
widdles123514343widdles
wide85235403wi__de_
widen94717973wi__den
widened12328053widened
wider94826353wi__der
wides94832823wi__des
widowed1534843widowed
wieldiest1334803wieldiest
wielding13286863wielding
wiener94513543wie_ner
wienie9229973wienie_
wienies102213683wienies
wifed125117743wi__fed
wifelier1434853wifelier
wigged124413583wi_gged
wiggled13299603wiggled
wiglet105519153wigl_et
wild85126513wi_l__d
wildered1336633wi_ldered
wilders113513503wi_lders
wildest113311273wi_ldest
wildly13328123wi_ldly
wilds94818203wi_ld_s
wile75944373wi_l_e_
wiles85437873wi_l_es
wilier93217073wi_lier
willer94021063wi_ller
willet95124833wi_llet
willie94116453willie_
willies103920153willies
willowed15156763willowed
wimbled15298153wimbled
wimped144211513wi_mped
wimpled15338823wimpled
winced124415343wi_nced
winched163110593winched
winder104025263wi_nder
windle104617953windle_
windles113518493windles
wined94434183wi__ned
winged114620833wi_nged
winked144018603wi_nked
winkled15299593winkled
winned104017013wi_nned
wintled11339843wintled
wiped114722083wi__ped
wired95327643wi__red
wised95123343wi__sed
wiselier1137363wiselier
wished134417513wi_shed
wisped123411893wi_sped
wissed104114643wi_ssed
wisted104120273wi_sted
witched163012193witched
wited94727143wi__ted
withed134416233wi_thed
witted104216813wi_tted
wived125121503wi__ved
wizened20275423wizened
woaded115211603w_oaded
wolfed13428013w_olfed
wooded114213683w_ooded
wooled103715503wool_ed
woolled1136643woolled
worded114316623w_orded
wounded12329763wounded
wreaked15369023wreaked
wrecked17418333wrecked
wrested113410933wrested
wyled124611843w_yl_ed
yelled104116253_yelled
yelped12439363_yelped
yield9519693yiel__d
yielders12164743yielders
yields10466843yield_s

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273708.17016404.8
3Display Results3703700.1262936.5
 (SQL Overall)1786913708.45221141.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.