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

272 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
kernites126911(None) 
kernite1159471kernite_
arenites8917102arenites
bornites10310982bornites
cerites94823432cer_ites
ferrites112312832ferrites
herniates1247332herniates
kainites1238792kainites
kentes105118652ke_n_tes
kermises14248312kermises
kernes104717532kern__es
kerries113317912kerri_es
keynotes1543632keynotes
kyanites15216682kyanites
lenites7818442le_nites
perlites10316362perlites
reunites8312472reunites
sternites9310072sternites
tergites9310542tergites
termites10313692termites
verites103822262ver_ites
vernixes1836052vernixes
aconites10314353aconites
aerates74627493aer_ates
aeries64737783aer_i_es
aerolites9312583aerolites
alunites8310703alunites
ankerites1348523anker_ites
arenite71017713arenite_
barites94322333bar_ites
beanies93821093beani_es
bennies93917313benni_es
berates94126873ber_ates
berimes115216643ber_imes
berlines102315453berlines
bernicles1345403bernicles
berries94423553berri_es
bornite9311183bornite_
burkites1436673burkites
burnies94017823burni_es
byrnies12378573byrni_es
carnies94123963carni_es
cenotes92814543ce_notes
cerastes101111093cerastes
cerates95428253cer_ates
cercises12410933cercises
cerises94722253cer_ises
cerite84724873cer_ite_
certes84623083cer__tes
cerusites1146523cerusites
cervices1537133cervices
cervixes2054603cervixes
cordites11314623cordites
cornices12713293cornices
crinites10612763crinites
curites93919863cur_ites
cyanites132610163cyanites
denies74729643de_ni_es
denotes83817003de_notes
derates84028893der_ates
derbies103016053derbi_es
derides93420853der_ides
derives114017813der_ives
dermises112512023dermises
dernier83011943derni_er
derries83124623derri_es
derrises93012783derrises
despites11410313despites
dunites8313593_dunites
dunnites947173dunnites
ebonites1039233ebonites
elites66027123_e_lites
enates64026433_e_nates
endites83717063_endites
equites162212493_equites
eremites10312603_eremites
ergates8314493_ergates
ermines9416673_ermines
ernes55224813_ern__es
eternises9119453eternises
eternities1048063eternities
eternizes18118013eternizes
evites94916473_e_vites
excites16310633_excites
felsites1138073felsites
ferities111416713fer_ities
ferlies103216693ferli_es
fernier103110823ferni_er
ferniest1132214153ferni_est
ferrates113013423ferrates
ferries103521083ferri_es
ferrite103312753ferrite_
finites10315923_finites
fornices1369103fornices
frites94922483_fr_ites
gahnites1235703gahnites
genies75324943ge_ni_es
gentes75324163ge_n_tes
granites92116363granites
gunites8313123_gunites
heinies102514543heini_es
henries102718283henri_es
hermits12312143hermit_s
herniae1039043herniae_
hernias10310773herni_as
herniate1148113herniate_
herniated1346013herniated
heroines112916573heroines
heroizes202610983heroizes
herries104025073herri_es
hessites1138613hessites
hornitos1145393hornitos
ichnites1345743ichnites
ignites81310583_ignites
jennies143511623jenni_es
jerkies183411583jerki_es
jerries143817513jerri_es
kainite1149543kainite_
kainits1137763kainit_s
karates115617473kar_ates
kebbies1537253kebbi_es
kellies113516853kelli_es
kelpies13289903kelpi_es
kenches163912273ke_nches
kennings13315273kennings
kente95821073ke_n_te_
keratins122313483keratins
keratitis1345873keratitis
kermes124616133ker__mes
kermis124012393kermi__s
kerne94718223kern__e_
kerned114112933kern__ed
kernel104010593kern__el
kerneled1344033kerneled
kernels11417953kern_els
kerning124010893kerni_ng
kerns94719563kern___s
kerosines1357103kerosines
kerrias11289513kerri_as
kewpies16246923kewpi_es
keynote1443903keynote_
keynoted1642783keynoted
keynoter1542383keynoter
keynoters1642313keynoters
khanates1535733khanates
kites95432543k___ites
knifes136210213k__nifes
knits93914743k__nit_s
knives13458553k__nives
kraits104912203k_rait_s
krises105016083k_r_ises
kunzites2143243kunzites
kyanises15206393kyanises
kyanite14237313kyanite_
kyanizes24205283kyanizes
kyries133411373kyr_i_es
lenite6719983le_nite_
lenited8812433le_nited
lenities8315943le_nities
leucites1037333leucites
lignites9129613lignites
mannites10312613mannites
marlites103415263marlites
marmites122212793marmites
meanies93620743meani_es
meinies92516073meini_es
melanites11410733melanites
melinites11310413melinites
mercies113817563merci_es
merises93421423mer_ises
merited10313853mer_ited
merits8320873mer_it_s
neonates8310063neonates
nereides938503nereides
nervines112310463nervines
nites55736343___nites
norites74018803nor_ites
ornithes1136423_ornithes
overbites14310983overbites
pearlites1138233pearlites
pelites93821993pe_lites
penates93321603pe_nates
penises9318193pe_nises
penlites10312273penlites
pennies94218813penni_es
pennines103112043pennines
peonies93620153peoni_es
peritus9311803per_itus
perlite9317323perlite_
permits11314003permit_s
permutes1238713permutes
perniones1148593perniones
perries93226603perri_es
petites93820203pe_tites
pinites9319533_pinites
preunites1138933preunites
pyrites12812203pyr_ites
recites93524583re_cites
reignites1046933reignites
reincites1148493reincites
reinvites1287033reinvites
reknits1137073reknit_s
rentes65431193re_n_tes
requites171511763requites
reraises8415643reraises
rerises73525883rer_ises
reroutes8312223reroutes
resites74027793re_sites
respites10513243respites
retinites9313503retinites
reunite7312713reunite_
reunited939713reunited
reuniter838323reuniter
reuniters936423reuniters
rewrites11311063rewrites
rites54442553__r_ites
selenites91312093selenites
senates73322613se_nates
seniles72618023se_niles
sennits73811283sennit_s
serenities10411063serenities
seriates82620673seriates
series64540973ser_i_es
serines74229543ser_ines
serrates82617023serrates
serries73925353serri_es
services1338573services
sienites8311913sienites
skerries12168673skerri_es
sorites73825243sor_ites
sprites94220333spr_ites
sternite8310543sternite_
syenites1138943syenites
tectites1039993tectites
tektites1236613tektites
tennies73017973tenni_es
tennises82810133tennises
tergite8311003tergite_
termite9313893termite_
ternate7415483ternate_
ternes65422903tern__es
ternions838813ternions
terries73425633terri_es
terrines82117553terrines
territs72714503territ_s
thermites1438043thermites
turgites937783turgites
unites65024853__unites
uranites82514643uranites
velites103417303ve_lites
venines103516613ve_nines
venires103012453ve_nires
verbiles1338923verbiles
verditer1236223verditer
verditers1344993verditers
veritas103012753ver_itas
verite94323443ver_ite_
verities111418043ver_ities
vernicles1446133vernicles
vernier102711273verni_er
verniers11227843verniers
versines112213823versines
verstes104014283ver_stes
vertices13612283vertices
websites1335183websites
weenies102915093weeni_es
wernerites1344943wernerites
writes94420333_wr_ites
yentes95517603ye_n_tes
yperites13310153yper_ites
zeniths1935153ze_niths
zeolites1738383zeolites

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622727.01620832.7
3Display Results2722720.1102472.7
 (SQL Overall)1786912727.54923670.8
 
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.