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

265 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
yielded1218471(None) 
bielded11226711bielded
fielded12206811fielded
wielded12216681wielded
yielder11175111yielder
fielder11217412fielder
gelded94512112_gelded
gilded94413222gi_lded
melded104714712_melded
milded104416152mi_lded
shielded1334392shielded
welded114013382_welded
wielder11197672wielder
wilded113714502wi_lded
yelled104116252y_elled
yelped12439362y_elped
yield9519692yiel__d
yielders12164742yielders
yields10466842yield_s
aided75828933ai__ded
ailed66240283ai_l_ed
aisled74516183aisl_ed
amended11328303amended
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
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
middled123311893middled
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
outyielded1541903outyielded
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
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
unended92811823unended
ungelded1147403ungelded
unwelded1337133unwelded
upended11267323upended
veiled103714543veil_ed
vended114416353_vended
vialed105112593vial_ed
vialled1156843vialled
viewed1345993vie_wed
wedded123811833_wedded
weeded113914873_weeded
weirded1234513weirded
welder102914413_welder
welled103820213_welled
welted103715823_welted
wended113616153_wended
whelmed16375153whelmed
whelped16355633whelped
widdled133511233widdled
wield95213913wiel__d
wielders12196613wielders
wieldier1234283wieldier
wields10469623wield_s
wieldy13476183wield_y
wilder103616473wi_lder
wiled95231553wi_l_ed
willed104722453wi_lled
willied114611563willied
wilted103915713wi_lted
winded114918213wi_nded
windled123713483windled
yarded114714023y_arded
yawled13459983yawl_ed
ycleped1543393ycleped
yeaned103813903y_eaned
yeld811423873y_el__d
yeller94214513y_eller
yelper11458783y_elper
yenned10409383y_enned
yerked14509373y_erked
yessed104511163y_essed
yeuked14456233y_euked
yielding13205033yielding
yipped143613283yi_pped
yirred10426963yi_rred
yodeled1236853yodel_ed
yodelled1334593yodelled
yodled11389643yodl_ed
yolked14367153y_olked
yowled133811083yowl_ed

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.1561145455.1
2DLD Change Limit1340272656.62320236.6
3Display Results2652650.0962760.4
 (SQL Overall)1786912656.87525991.4
 
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.