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 “herds” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

224 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
herds9642468(None) 
hards96435651hards
heads95127111heads
heeds95420421heeds
herbs105520501herbs
herd84933061herd_
heres86245901heres
herls85226431herls
herms105626431herms
herns84825581herns
heros84930861heros
hers75844871her_s
hurds95219071hurds
nerds65719251nerds
sherds105614721sherds
bards87139642bards
beads85429502beads
beards94116672beards
beds75937782be_ds
bends85628972bends
bergs84718042bergs
berks115423122berks
berms95323662berms
birds85421332birds
burds84626062burds
cards85137932cards
ceres75540012ceres
ceros74726072ceros
chards125119732chards
cherts115617232cherts
chords125214632chords
cords86030622cords
creds85418772creds
curds85725612curds
deads75726912deads
deeds75423762deeds
derms85022892derms
eds46638922_e_ds
elds56324852_elds
ends56528522_ends
eras45441502_eras
ergs55523812_ergs
erns45428232_erns
eros45238452_eros
errs45622532_errs
ers36046282_er_s
fards96629842fards
feds85234312fe_ds
feeds94921142feeds
fends96324972fends
feods99516852feods
feres86038182feres
ferns85220082ferns
feuds95914882feuds
fords95328182fords
geds66730812ge_ds
gelds75118342gelds
germs85118872germs
girds74816992girds
haeres94017032haeres
hands95327382hands
hard85443502hard_
hardy125622062hardy
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
head87137172head_
heady125117262heady
heals85733452heals
heaps105223222heaps
heard95222752heard_
hears86737372hears
hearts96218942hearts
heats85838402heats
hebes105521672hebes
hecks145220652hecks
heed86437602heed_
heels85625532heels
hefts116218152hefts
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
held85330402held_
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
hemes105031082hemes
hemps126917332hemps
hems95534942he_ms
henrys12366102henrys
hens75642572he_ns
hents87330742hents
her66547812her__
heralds1137712heralds
herb94730962her_b
herby134715312herby
herded114215642herded
herder104516462herder
herders113914122herders
herdic123112302herdic
herdics13249522herdics
here76447102her_e
heredes11313132heredes
heresy125011232heresy
herl75834552her_l
herm95636152her_m
herma105318882herma
hern76134892her_n
hero74635782her_o
heroes94923822heroes
heron85025502heron
herons94820542herons
herpes115517322herpes
herry114922472herry
hertz174919042hertz
hes66654202he__s
hests85829932hests
heths116317782heths
hets75547202he_ts
hews105631572he_ws
hexads17468192hexads
hexes155123042hexes
hinds96721472hinds
hires86134342hires
hoards104912622hoards
hods87239862h_ods
hoers85724922hoer_s
holds94623242holds
hoods95124082hoods
horas86333102horas
horde94623052horde
hordes104921632hordes
horns86125332horns
hurls86522712hurls
hurts86922822hurts
jerids142810942jerids
jerks166514892jerks
kerbs115013672kerbs
kerfs125413572kerfs
kerns94719562kerns
lards65331862lards
leads66028492leads
lends65326252lends
leuds66214812leuds
lords64923502lords
meads85425322meads
meds75735362me_ds
meeds84920272meeds
melds84822382melds
mends84927692mends
mercs96020452mercs
merde84320122merde
merdes94518602merdes
meres75143572meres
merks114722402merks
merls77423902merls
nards65928462nards
needs65719632needs
nerd56624942nerd_
nerdy95014702nerdy
nerts55924982nerts
nurds65518522nurds
pards85634332pards
peds75835242pe_ds
pends85527192pends
perdu84216272perdu
perdus93711272perdus
perdy115417332perdy
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
reads64835272reads
redds74617832redds
reds56042862re_ds
reeds65430902reeds
rends65129952rends
sards64736182sards
seeds64330062seeds
sends65528242sends
seres55448892seres
serfs84922012serfs
sers45746652ser_s
shards104319172shards
sheds96122702she_ds
shends105313772shends
sherd96321152sherd_
shreds105613052shreds
sords64527802sords
surds65624662surds
teds54932572te_ds
tends65425582tends
terms75523472terms
terns55226872terns
theres96525472theres
therms115914872therms
thirds10438602thirds
turds65021692turds
urds55922432_urds
velds95615582velds
vends95520892vends
verbs104614392verbs
verts85724732verts
wards97734402wards
weds86628932we_ds
weeds95222212weeds
weirds10478052weirds
welds94719162welds
wends95822812wends
wheres125917432wheres
words95425072words
xerus12313332xerus
yards95324612yards
yerks125416562yerks
yirds96612512yirds
zeds145821802ze_ds
zerks185113822zerks
zeros144918112zeros

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538002241.61033416.1
3Display Results2242240.0633555.6
 (SQL Overall)1786912241.98390111.4
 
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.