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

356 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
herrings1237953(None) 
hearings123611851hearings
herring113615881herring_
bearings113912252bearings
earings84517712_earings
earrings9299632earrings
erring73816482_erring_
furrings12317142furrings
gearings10359502gearings
harpings14379772harpings
headings133510492headings
hearing113324162hearing_
heelings12359752heelings
heiring113312902heiring_
helpings14255652helpings
herding122915122herding_
heroines112916572heroines
heroins103518012heroin_s
herries104025082herri_es
herrying15147032herrying_
hornings12238362hornings
hurlings12388212hurlings
nervings12256322nervings
sergings10299212sergings
servings12249222servings
shearings13337562shearings
shirrings13245322shirrings
terrines82117552terrines
airings83913843_airings
armings103811503_armings
averring12239063averring_
barring104021593barring_
beadings123711783beadings
bearing103624773bearing_
beatings114113233beatings
beddings13407923beddings
befringe1484513befringe
befringes15104453befringes
beings94613033be__ings
bellings113811153bellings
beltings11369253beltings
berlines102315453berlines
berlins93216013berlin_s
berming123614833berming_
berries94423553berri_es
berrying14137383berrying_
birdings12378823birdings
birlings11359613birlings
birring103713063birring_
borings103614243_borings
brewings14296693brewings
brings94618433__brings
burnings11387623burnings
burring104016993burring_
cardings123812643cardings
carlings114015863carlings
carpings133812393carpings
carvings143810213carvings
ceilings11397993ceilings
centrings12227603centrings
cering94522533ce_ring_
charring142913163charring_
cheering143612703cheering_
cherries131812993cherri_es
chirring142610173chirring_
churnings15233403churnings
churring14298653churring_
clearings12286063clearings
cordings123011363cordings
curbings13407313curbings
curlings114110383curlings
curring103616843curring_
darings93713653_darings
darlings103710383darlings
darnings10378553darnings
dealings103510703dealings
deckings16346683deckings
deraigns1034883deraigns
derricks1544433derricks
derries83124623derri_es
derringer1144593derringer
derringers1243843derringers
derris73615273derri__s
derrises93012783derrises
earing75235483_earing_
earnings9419333earnings
earring83519013earring_
eatings84616443_eatings
edgings10256243_edgings
endings92910443_endings
eringo739553_e_ringo
eringos836913_e_ringos
erlkings1333563_erlkings
ermines9416673_ermines
errands847603_errands
errants7410643_errants
errhines1136413_errhines
erringly1237773_erringly
fairings12388193fairings
farmings14298223farmings
fearing113520033fearing_
feelings12338933feelings
feltings12317903feltings
fencings14225663fencings
ferretings14133503ferretings
ferriage1245463ferriage
ferriages1345663ferriages
ferries103521083ferri_es
ferrites112312833ferrites
ferrying15146253ferrying_
firings114112333_firings
forgings13287703forgings
furring114013143furring_
garring93116713garring_
gearing92818843gearing_
geldings11316163geldings
gherkins1643993gherkin_s
hangings13258583hangings
haring104233003h_aring_
harking154120943harking_
harmines132715143harmines
harming133717933harming_
harmins123716723harmin_s
harping134118383harping_
harpins123615703harpin_s
harriers113712433harriers
harries103525503harri_es
harrying15157643harrying_
hawkings19336133hawkings
hayings14379393h_ayings
hazings20378343h_azings
heading122919113heading_
healing113922963healing_
heaping133015853heaping_
hearsing1239383hearsing_
hearting12513123hearting_
heating114024323heating_
heaving144114763heaving_
hedging13348953hedging_
heeding123515063heeding_
heeling113618513heeling_
heezing20349873heezing_
hefting144510913hefting_
heiling113616363heiling_
helling114623223helling_
helming133712003helming_
helping133512223helping_
helving144011133helving_
hemins113417573he_min_s
hemlines13310623hemlines
hemming15269973hemming_
henries102718283henri_es
henting113719653henting_
heparins13310123heparin_s
herdics13249523herdi_cs
herein93717793herein__
hereinto1145433hereinto
heriots10312063he_riots
hermits12312143hermi_ts
hernias10310773herni_as
herns84825583he_r_n_s
heroics122912003heroi_cs
heroin94420593heroin__
heroine103517493heroin_e
heroinism1446873heroinism
heroisms1338693heroisms
heroizes202610983heroizes
herons94820543he_ron_s
herried113514473herri_ed
hewing134514243he_wing_
hexing174210513he_xing_
hidings12349703h_idings
hildings13347503hildings
hirelings1365763hirelings
hiring104421603h_iring_
hissings12556753hissings
hoardings14315113hoardings
holdings13297743holdings
hoppings16306523hoppings
hording123517053hording_
horning113015003horning_
horsing113215583horsing_
housings12307483housings
huntings12328053huntings
hurling113616413hurling_
hurriers11358893hurriers
hurries103919653hurri_es
hurrying15145533hurrying_
hurting113914033hurting_
huskings16276043huskings
hustings12378683hustings
jarring153613193jarring_
jeering153513043jeering_
jerking19308923jerking_
jerkins18358253jerkin_s
jerrids15277743jerri_ds
jerries143817513jerri_es
jestings16368023jestings
kartings13418523kartings
keepings15345943keepings
keglings14245233keglings
kennings13315273kennings
kerbing14308483kerbing_
kerfing15307533kerfing_
kerning124010893kerning_
kerrias11289513kerri_as
kerries113317913kerri_es
leadings103511243leadings
leanings94010183leanings
learnings1094323learnings
leasings9379843leasings
leavings12407493leavings
leering83417643leering_
leggings11316193leggings
lemmings13254733lemmings
lordings10368503lordings
markings153410243markings
marlings113713493marlings
marring103319553marring_
meanings11329163meanings
meetings11287413meetings
mendings12338303mendings
merging112711763merging_
merinos9311983me_rinos
merlins93015813merlin_s
merriness1138293merriness
metring103215293metring_
moorings11257713moorings
mornings11297923mornings
nearing83020333nearing_
neckings15346113neckings
nervines112310463nervines
nerving112910833nerving_
nettings9288103nettings
neurines8311193neurines
nursings9325773nursings
outrings92811053outrings
pairings11398313pairings
pargings123410163pargings
parings104219213_parings
parkings153610683parkings
parring103222063parring_
partings113513733partings
peelings11339523peelings
peering103520353peering_
perking143716463perking_
perming123416093perming_
perries93226603perri_es
perrons93115483perron_s
pettings11349703pettings
pharmings17254723pharmings
piercings1453263piercings
purgings12347293purgings
purlings113910283purlings
purring104515823purring_
readings103512643readings
rearing83128783rearing_
redwings13305733redwings
reedings103510363reedings
reelings94012563reelings
regrinds1035533regrinds
rehearings14214573rehearings
reprints1039903reprints
rerigs74014793re_ri_gs
resprings12156253resprings
restrings10159293restrings
rings65029173___rings
roarings9248293roarings
sacrings11278923sacrings
searing83330923searing_
seatings93614303seatings
seeings84411293se_eings
seemings11337643seemings
seisings9398523seisings
seizings18326473seizings
sereins73716123serein_s
serging93416673serging_
serines74229543se_rines
sering74731813se_ring_
seringa83310743se_ringa
seringas9339003se_ringas
serins64029673se_rin_s
serranos857873serranos
serries73925353serri_es
serrying12167703serrying_
serving113014983serving_
settings93810073settings
sewings11369173se_wings
shealings13317563shealings
shearing123915903shearing_
shearlings1443533shearlings
sheering123715103sheering_
sheetings13256713sheetings
shelvings16283823shelvings
sherries111812903sherri_es
sherris10168803sherri__s
sherrises12156873sherrises
shirring122910443shirring_
shirtings13276603shirtings
shorings12269483shorings
showrings1644063showrings
soarings93210393soarings
sorings83817253_sorings
speerings12276843speerings
springs104415923_springs
sterlings10308753sterlings
stirrings10224693stirrings
strings84617133_strings
subrings11229883subrings
surfings12268073surfings
tarring83318303tarring_
tearing84021493tearing_
terming104016003terming_
terminus1037393terminus
terrains8410323terrain_s
terranes82514433terranes
terrenes82212603terrenes
terriers84210823terriers
terries73425633terri_es
terrine72517573terrin_e
territs72714503terri_ts
tourings9277373tourings
turnings9287233turnings
unerring9311273unerring_
veering113213683veering_
veilings12357313veilings
veinings12306433veinings
verdins112812333verdin_s
verging123812303verging_
versines112213823versines
versing112314193versing_
vestings12359143vestings
warnings12358453warnings
warring113717973warring_
wearing113318863wearing_
webbings1633243webbings
weddings14355533weddings
weepings14346483weepings
weltings12388203weltings
westings12429803westings
wettings12348403wettings
wheelings16284943wheelings
wherries14179033wherri_es
wherrying1953003wherrying_
whirring15286283whirring_
wirings113910113_wirings
wordings13328563wordings
workings16337503workings
wrings104012973__wrings
yealings12257703yealings
yearlings1384203yearlings
yearnings1393553yearnings
yerking15368813yerking_
yirring11307763yirring_
zebrines1935883zebrines
zeroing1738343zeroing_

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 Filter1786911461620.436409841.7
2DLD Change Limit1461623567.53319402.9
3Display Results3563560.1402542.9
 (SQL Overall)1786913568.10922036.1
 
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.