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

197 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
herniae103904(None) 
hernia9312291hernia_
hernial10310431hernial
hernias10310771hernias
herniate1148111herniate
feriae95618602fer_iae
heinie92512662heini_e
hermae115314472her_mae
herniated1346012herniated
herniates1247332herniates
heroine103517482heroine
heroize193210962heroize
kernite1159472kernite
teniae64517352te_niae
aeonian738353aeonian
aerial64625713aer_ial
aerie54634603aer_i_e
arenite71017713arenite
beanie83618593beani_e
berime105317333ber_ime
berline93716853berline
bernicle1245443bernicle
bornite9311183bornite
burnie83715413burni_e
byrnie11348573byrni_e
cardiae10713713cardiae
carinae94318593carinae
carnie84421093carni_e
ceria75125353cer_ia_
cerias83321983cer_ias
cerise84822043cer_ise
cerite84724873cer_ite
cervine122610803cervine
cornice11612933cornice
curiae84518373cur_iae
denial74720513de_nial
deride84420033der_ide
derive103817043der_ive
dernier83011943dernier
eerie55228533eer_i_e
eonian6311833_eonian
ermine8416923_ermine
erne46727433_ern__e
eternise8119663eternise
eternize17118363eternize
feria85922713fer_ia_
ferial94621253fer_ial
ferias95020393fer_ias
ferine96422583fer_ine
ferlie92814053ferli_e
fernier103110823fernier
fernlike1535243fernlike
ferriage1245463ferriage
ferrite103312753ferrite
fertile10311733fertile
ferulae10309603ferulae
genial74917613ge_nial
genie66124923ge_ni_e
geranial949283geranial
harmine122816193harmine
hebraize2244453hebraize
heinies102514543heinies
heliac111010893he_liac
hemline12311073hemline
hempie132410563hempi_e
henbane1237353he_nbane
hence104920043he_n_ce
henge94819833he_n_ge
henlike1448693henlike
henna84414043he_nna_
hennaed1135103he_nnaed
hennas94211803he_nnas
hennish1336863hennish
henries102718283henries
herbage1337003herbage
herbal112513493her_bal
herbier1239593herbier
herblike1735883herblike
herdic123112303herdi_c
herdics13249523herdics
herding122915123herding
herdlike1636113herdlike
herdman13238423herdman
here76447103her___e
hereat93527413her_eat
herein93717793herei_n
heriot9422343her_iot
heritage1246533heritage
herma105318883her_ma_
hermai118912863her_mai
hermit11519443hermi_t
hermitage1543863hermitage
hermits12312143hermits
hern76134893hern___
herns84825583hern__s
heroic113516923heroi_c
heroical13410023heroical
heroics122912003heroics
heroin94420593heroi_n
heroines112916573heroines
heroins103518013heroins
heroism12311013heroism
heroized21298453heroized
heroizes202610983heroizes
herried113514453herried
herries104025073herries
herring113615883herring
hessian1035853hessian
hessite1038993hessite
hircine1239143hircine
hornier103012463hornier
hornily1338283hornily
horning113015003horning
hornist102314823hornist
hornito1047073hornito
hornlike1536503hornlike
hornpipe1542763hornpipe
hydriae14246903hydriae
hyenine1336953hyenine
inertiae8411473inertiae
kerne94718223kern__e
kerning124010893kerning
kernites1269113kernites
kerria10339913kerria_
kerrias11289513kerrias
lenite6719983le_nite
leonine7311233leonine
meanie83718393meani_e
mediae94217413me_diae
meinie82614523meini_e
menial84223033me_nial
mensae84114053me_nsae
nervine102510633nervine
overnice13310093overnice
penial84120893pe_nial
penile82219603pe_nile
pennae84314033pe_nnae
pennia84412973pennia_
pennine93712953pennine
perdie94718513perdi_e
pereia85217983pereia_
perinea9313033perinea
perlite9317323perlite
permian112612283permian
pernio8513143perni_o
rediae74221993re_diae
reginae84713453reginae
reraise7316313reraise
rerise64325633rer_ise
retinae75517333retinae
reunite7312713reunite
senile63420213se_nile
serial64625863ser_ial
seriate73722473ser_iate
serine65432673ser_ine
serosae7310243serosae
service1239093service
servile10310643servile
sheenie10159493sheeni_e
sternite8310543sternite
striae65422273str_iae
taeniae739083taeniae
tenia55324483te_nia_
tenias64720073te_nias
terbia8311153terbia_
terbias9310743terbias
tergite8311003tergite
termite9313893termite
ternate7415483ternate
terne56426153tern__e
ternion739493ternion
terrae62915213ter_rae
terrine72517573terrine
tertial7313863tertial
tertian7511193tertian
theriac1239143ther_iac
therian10311293ther_ian
thermae125310503ther_mae
thermite1339033thermite
venae85920983ve_n_ae
venial94218283ve_nial
venine93718433ve_nine
venire93513693ve_nire
verbiage1444553verbiage
verbile1249863verbile
verite94323443ver_ite
vermian12329713vermian
vernal93514213vern_al
vernicle1346433vernicle
vernier102711273vernier
vernix1636633verni_x
vernixes1836053vernixes
versine102515173versine
weenie92612023weeni_e
xenia124814773xe_nia_
xenial133414903xe_nial
xenias133712973xe_nias

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271977.11018850.5
3Display Results1971970.0603283.3
 (SQL Overall)1786911977.57623586.5
 
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.