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

306 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
adhered123923(None) 
adhere10310331adhere_
adherend1343861adherend
adherer1137561adherer
adheres11310161adheres
adeemed1145392adeemed
adherends1443262adherends
adherent1247772adherent
adherers1296912adherers
adjured1634872adjured
admired1135702admired
adored84714232ad_ored
adverted1336102adverted
altered83215732altered
angered93013472angered
ashlered1244622ashlered
badgered1336212badgered
cohered133514692cohered
fathered151510432fathered
gathered13149372gathered
inhered11313162inhered
kashered1636402kashered
laddered1136742laddered
lathered121512322lathered
ochered132610282ochered
sphered133512312sphered
ushered1139152ushered
aahed917816443aah__ed
abhorred1443493abhorred
abjured1735073abjured
acceded1336093acceded
ached119227833ach__ed
achene11313813achene_
achenes12313493achenes
achieved1743713achieved
acred87126353a__cred
adapted1135833adapted
added84918433ad__ded
addend9458453adde_nd
adder75419593adder__
adders84315703adder_s
addled94112513ad_dled
adduced1274353adduced
adeem8311803ad_e_em
adherence1564883adherence
adherents1345553adherents
adhering1338873adhering
adjure1435833adjure_
adjurer1534803adjurer
adjures1536223adjures
admire949933admire_
admirer1035513admirer
admires1038663admires
admixed1833733admixed
adopted1136253adopted
adore65723663ad_ore_
adorer74713443ad_orer
adores74420713ad_ores
adorned9256883adorned
adsorbed1243433adsorbed
advected1534533advected
adverb12265413adver_b
adverbs13254273adverbs
adverse1145953adverse
advert103215773adver_t
adverts11308513adverts
advised12136043advised
adzed166012543ad__zed
aeried74221863a__eried
afeared1176833afeared
agreed84712503agre_ed
ahead96817053a_he_ad
ahed89536253a_h__ed
aired66032923a__ired
alerted82512223a_lerted
aliened81011743aliened
alleged9389313alleged
allured8299173allured
alterer72713993alterer
amerced1256523a_merced
ampere10514413ampere_
amperes11313983amperes
anchored1438593anchored
aneared8512743aneared
aneled74719273a_neled
angeled93211493angeled
annexed1535753annexed
answered1235483answered
anteed75616113ante_ed
anthemed1446953anthemed
antherid12611093antherid
antired82316193antired
antlered938253antlered
apheses12610703apheses
appeared1336143appeared
arbored103811603arbored
armored102610473armored
ascared10399523ascared
ashamed1336243ashamed
ashed97829773ash__ed
ashlared1253933ashlared
ashore9414613ashore_
aspersed11428293aspersed
aspired1068173aspired
asserted957903asserted
assured858373assured
attired8238913attired
augured987193augured
authored1238263authored
averred11237593averred
averted112211613a_verted
axseed1456993axse_ed
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
blathered15168353blathered
bothered142110393bothered
bowered133113043bowered
cacheted16148233cacheted
cambered15128993cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043capered
careered1139493careered
cashiered1543403cashiered
catered103117763catered
cered85227443__cered
chared125423693_chared
cheered133713293cheered
chefed155010563_chefed
chewed154415013_chewed
chored125321883_chored
ciphered1637053ciphered
cohere112716993cohere_
coherer122912783coherer
coheres122917693coheres
coshered14610293coshered
covered133315293covered
cowered133214643cowered
cyphered1934653cyphered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
dared75935013_d_ared
davened124610073davened
deed65340903_d_e_ed
deeded94615543_deeded
deemed104713063_deemed
deked115718533_d_eked
deled75326543_d_eled
dere56845903_d_ere_
dewed105020303_d_ewed
dieted83115493_dieted
dithered13189293dithered
doddered1234943doddered
dowered122811553dowered
dreed75222843_dre_ed
dueled84813663_dueled
dueted84113593_dueted
dured75025403_d_ured
entered82718883entered
faltered122810983faltered
feathered16188893feathered
fevered14339723fevered
fibered1337643fibered
fleered11309503fleered
foddered1434553foddered
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gatherer12147903gatherer
hachured1744393hachured
haltered123112553haltered
hammered16218843hammered
hampered16239923hampered
hankered16289443hankered
hared95742183__hared
havered144011453havered
heathered16149463heathered
heed86437603__he_ed
heired103813043__heired
herbed123513453__herbed
herd84933063__her_d
herded114215643__herded
here76447103__here_
heres86245903__heres
hewed125619433__hewed
hexed165615763__hexed
hired95226263__hired
homered133212713homered
hovered143411573hovered
inhere9313713inhere_
inheres10315173inheres
jabbered2034433jabbered
jeered143912793_jeered
juddered1833583juddered
koshered1636063koshered
laagered1055853laagered
lackered15108673lackered
ladened979053lad_ened
lagered92311153lagered
lappered13288213lappered
latherer111310443latherer
laveered1235253laveered
lawyered1534033lawyered
layered11259413layered
leathered13148713leathered
lechered1437523lechered
leered73816223_leered
levered114212303levered
livered113111633livered
lowered112711913lowered
maddened1334893maddened
mammered12237653mammered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
metered103514013metered
mitered103213233mitered
mothered142310103mothered
nattered92011623nattered
ochred12328003och_red
odored8399223od_ored
offered1436143offered
ordered9108533ordered
osiered837123osiered
overed102216623_overed
paltered113012483paltered
pampered15229223pampered
pandered121812573pandered
papered122513163papered
pattered112714203pattered
paupered13216933paupered
peered93819483_peered
petered103314963petered
pothered142311043pothered
powered132911643powered
queered17117213queered
racheted14149503racheted
raftered1237663raftered
rapiered1136053rapiered
rehired115013153rehired
revered112819333revered
rogered939553rogered
sabered103213023sabered
sacheted14127833sacheted
saddened1135343saddened
saggered11237553saggered
schemed1577753schemed
sered65737293__sered
severed113513863severed
sewered112911243sewered
shared105829063_shared
sheared114516003_sheared
sheered113515453sheered
sherd96321153_sher_d
shewed134716183_shewed
shored105723643_shored
shred98125613_sh_red
slathered13148533slathered
sneered83113973sneered
sobered102912433sobered
speered103614813speered
sphere113313653sphere_
spheres123114353spheres
spiered104412463spiered
steered83615253steered
supered10316123supered
syphered1755013syphered
tabered103311593tabered
tampered13279463tampered
tapered102612933tapered
tattered92011443tattered
teddered11255183teddered
tethered1238493tethered
themed125912583_themed
there87527393_there_
theres96525473_theres
tiered73613973_tiered
tochered1437913tochered
towered112911403towered
ulcered1037973ulcered
umbered121510113umbered
unhired112512153unhired
uttered82712433uttered
veered103612743_veered
wafered14288433wafered
wagered12299333wagered
waitered1238753waitered
wandered132110793wandered
watered113014953watered
wavered142910433wavered
weathered16168513weathered
where117019423_where_
wheres125917433_wheres
whored135512123_whored
withered15169433withered
wuthered15157433wuthered
yabbered1633963yabbered
yammered16225763yammered
yattered12239533yattered

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273067.15618729.3
3Display Results3063060.1102781.8
 (SQL Overall)1786913067.42224075.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.