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

266 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
kernite115947(None) 
kernites1269111kernites
arenite71017712arenite
bornite9311182bornite
cerite84724872cer_ite
ferrite103312752ferrite
herniae1039042herniae
herniate1148112herniate
kainite1149542kainite
kente95821062ke_n_te
kerne94718212kern__e
kerning124010892kerning
keynote1443902keynote
kyanite14237312kyanite
lenite6719982le_nite
perlite9317312perlite
reunite7312712reunite
sternite8310542sternite
tergite8311002tergite
termite9313892termite
ternate7415482ternate
verite94323442ver_ite
aconite9315473aconite
aerate64830553aer_ate
aerie54634603aer_i_e
aerolite8315053aerolite
alunite7311633alunite
ankerite1248923anker_ite
arenites8917103arenites
barite84224813bar_ite
beanie83618593beani_e
berate84729023ber_ate
berime105317333ber_ime
berline93716853berline
bernicle1245443bernicle
bornites10310973bornites
burkite1337003burkite
burnie83715413burni_e
byrnie11348573byrni_e
carnie84421093carni_e
cenote83715843ce_note
cerate84829463cer_ate
cerise84822043cer_ise
cerites94823433cer_ites
cerusite1047763cerusite
cervine122610803cervine
cordite10315253cordite
cornice11612933cornice
cornute939633cornute
crenate93317113crenate
crinite9513633crinite
curite85222943cur_ite
cyanite122710763cyanite
definite1239323definite
denote74118043de_note
derate74531233der_ate
deride84420033der_ide
derive103817043der_ive
dernier83011943dernier
despite10410123despite
dunite7315013_dunite
dunnite857333dunnite
ebonite9310293ebonite
eerie55228533eer_i_e
elite56230183_e_lite
enate54428143_e_nate
endite73817593_endite
eremite9312833_eremite
ergate7315143_ergate
ermine8416923_ermine
erne46727423_ern__e
erudite838483_erudite
eternise8119663eternise
eternity1146683eternity
eternize17118363eternize
evite85317683_e_vite
excite15310883_excite
felsite1039083felsite
feriae95618603fer_iae
ferine96422583fer_ine
ferity122813343fer_ity
ferlie92814053ferli_e
fermate122813003fermate
fernier103110813fernier
fernlike1535243fernlike
ferrate103014033ferrate
ferrites112312823ferrites
fertile10311733fertile
finite9316823_finite
gahnite1135973gahnite
genie66124923ge_ni_e
granite82017083granite
gunite7414403_gunite
heinie92512663heini_e
hermit11519443hermit_
hermits12312133hermits
hernia9312293herni_a
hernial10310433hernial
hernias10310773hernias
herniated1346013herniated
herniates1247323herniates
heroine103517483heroine
heroize193210963heroize
hessite1038993hessite
hornito1047073hornito
ichnite1245983ichnite
ignite71410573_ignite
kainit10414483kainit_
kainites1238793kainites
kainits1137763kainits
karate105320923kar_ate
kebbie1435803kebbi_e
keening123713153keening
kelpie12308613kelpi_e
kenning124010543kenning
kent86846963ke_n_t_
kentes105118643ke_n_tes
keratin113314153keratin
kerbing14308483kerbing
kerfing15307533kerfing
kermis124012393kermi_s
kermises14248313kermises
kern85326213kern___
kerned114112923kern_ed
kernel104010583kern_el
kerneled1344023kerneled
kernels11417953kernels
kernes104717523kern_es
kerns94719563kern__s
kerosine1238143kerosine
kerria10339913kerri_a
kerrias11289513kerrias
kerries113317913kerries
kewpie15465413kewpi_e
keynoted1642783keynoted
keynoter1542383keynoter
keynotes1543633keynotes
khanate1437073khanate
kirning12319333kirning
kite85338233k___ite
knife1210010133k__nife
knit85728143k__nit_
knits93914743k__nits
krait94726773k_rait_
kraits104912203k_raits
kunzite2053503kunzite
kyanise14236143kyanise
kyanites15216683kyanites
kyanize23265343kyanize
kyrie123712903kyr_i_e
lenited8812433le_nited
lenites7818443le_nites
lenity9612713le_nity
leonine7311233leonine
leucite937753leucite
lignite81310303lignite
mannite9312903mannite
marlite92917073marlite
marmite112413993marmite
meanie83718393meani_e
meinie82614523meini_e
melanite10512023melanite
melinite10411743melinite
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
neonate7311333neonate
nervate1039523nervate
nervine102510623nervine
nite45943583___nite
norite63221133nor_ite
ornate6315133_ornate
overbite13312083overbite
overnice13310093overnice
partite9317133partite
pearlite1039433pearlite
pelite84323003pe_lite
penile82219603pe_nile
penlite9313243penlite
pennate93314033pennate
pennine93712953pennine
perdie94718513perdi_e
periti8319953per_iti
perlites10316353perlites
permit10321683permit_
permits11314003permits
permute1138793permute
pernio8513143perni_o
petite84320653pe_tite
pinite8321243_pinite
preunite1039573preunite
pyrite11913313pyr_ite
recite83625113re_cite
reignite947233reignite
reincite1089703reincite
reinvite1177753reinvite
reknit10312533reknit_
reknits1137073reknits
rente54733783re_n_te
requite162012483requite
reraise7316313reraise
rerise64325633rer_ise
reroute7313963reroute
resite64128453re_site
respite9513033respite
retinite8314853retinite
reunited939713reunited
reuniter838323reuniter
reunites8312473reunites
rewrite10311143rewrite
rite45849453__r_ite
selenite81713103selenite
senate63725143se_nate
senile63420213se_nile
seniti64317213se_niti
sennit63117923sennit_
sennits73811283sennits
sente56432873se_n_te
serenate81914873serenate
serenity1168963serenity
seriate73722473seriate
serine65432673ser_ine
serrate73017533serrate
service1239083service
servile10310643servile
sienite7312713sienite
sprite84421773spr_ite
sternites9310073sternites
syenite1039773syenite
tectite9310583tectite
tektite1136883tektite
teniae64517353te_niae
tentie62521183te_ntie
terete6319333ter_ete
tergites9310543tergites
termites10313693termites
terne56426153tern__e
ternion739493ternion
terrine72517573terrine
territ63421373territ_
territs72714493territs
thermite1339033thermite
trite54730033_tr_ite
turgite837973turgite
unite54828383__unite
uranite72515693uranite
venine93718433ve_nine
venire93513693ve_nire
verbile1249863verbile
verditer1236223verditer
verites103822253ver_ites
verity123714853ver_ity
vernicle1346433vernicle
vernier102711273vernier
vernix1636633verni_x
vernixes1836053vernixes
versine102515173versine
verste94515633ver_ste
website1235323website
weenie92612023weeni_e
wernerite1245163wernerite
write85522833_wr_ite
yente86220043ye_n_te
yperite1249893yper_ite
zenith1839073ze_nith
zeolite1638903zeolite

Search took 7 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.1401276364.3
2DLD Change Limit1340272666.20321606.8
3Display Results2662660.0932860.2
 (SQL Overall)1786912666.43627764.3
 
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.