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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
kernes10471752(None) 
ernes55224811_ernes
kermes124616121kermes
kerne94718211kerne_
kerned114112921kerned
kernel104010581kernel
kernels11417951kernels
kerns94719561kern_s
ternes65422901ternes
aeries64737782aeries
akenes104817342ake_nes
arenes64928392arenes
benes75536232be_nes
bennes86019012bennes
bermes106023002bermes
ceres75540012cer_es
certes84623082certes
denes65639722de_nes
erne46727422_erne_
erns45428222_ern_s
erses55826802_erses
esnes54817362_esnes
feres86038182fer_es
ferns85220082fern_s
genes65133092ge_nes
genres75515622genres
heres86245902her_es
herns84825582hern_s
heroes94923822heroes
herpes115517322herpes
kanes95529372k_anes
karns96624142karn_s
kedges124812942kedges
keened114013622keened
keener104012832keener
keeners113610782keeners
keenest11410962keenest
keens95721182keen_s
keeves133711982keeves
kenned114411262kenned
kennel10369212kennel
kennels11387192kennels
kenos95220622ke_nos
kens85435232ke_n_s
kentes105118642kentes
kerbed13339692kerbed
kerbs115013672ker_bs
kerfed14358222kerfed
kerfs125413572ker_fs
kermess13396222kermess
kermis124012392kermis
kern85326212kern__
kernites1269112kernites
kerries113317912kerries
kersey1336782kersey
kerseys1433992kerseys
ketenes114813502ketenes
ketones115014502ketones
kexes166216812ke_xes
kines95039132k_ines
kirned11408622kirned
kirns95315452kirn_s
koines10415732koines
krewes1337922krewes
kyries133411372kyries
lenes54738522le_nes
leones64417722leones
liernes739622liernes
merces105720742merces
merdes94518602merdes
meres75143572mer_es
merges94122482merges
merles85322762merles
mesnes85216212mesnes
nenes55329672ne_nes
nerves94216192nerves
penes75839222pe_nes
peones83821042peones
peres76246642per_es
perses85428062perses
seines65029902seines
serenes73222902serenes
seres55448892ser_es
serges74225962serges
series64540972series
serines74229542serines
serves94423652serves
skeanes113610712skeanes
skenes104616632ske_nes
terces83921412terces
terne56426152terne_
terns55226872tern_s
verges104320172verges
vermes115019142vermes
verses94223762verses
verves124617882verves
zeroes154314342zeroes

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit82551972.78029694.6
3Display Results97970.0332939.4
 (SQL Overall)178691972.93960799.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.