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

323 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
heroines11291657(None) 
heroine103517491heroine_
heroins103518011heroin_s
heroizes202610981heroizes
berlines102315452berlines
ermines9416672_ermines
harmines132715152harmines
hemlines13310622hemlines
heroes94923832hero__es
heroics122912002heroi_cs
heroin94420592heroin__
heroinism1446872heroinism
heroisms1338692heroisms
heroize193210972heroize_
heroized21298462heroized
herons94820542hero_n_s
herries104025082herri_es
herrings12379532herrings
hexones17299142hexo_nes
kerosines1357112kerosines
nervines112310462nervines
serines74229542ser_ines
serotines9312072serotines
terrines82117552terrines
versines112213822versines
aeries64737783aer_i_es
aerobes9311493aero_bes
aerodynes1344603aerodynes
aerolites9312583aerolites
airlines8312793airlines
aroints7313133_aroints
arsines73518833_arsines
atropines1148883atropines
baronies10315023baronies
baronnes1038553baronnes
beelines103312803beelines
beguines11127213beguines
benzines1938213benzines
berimes115216643ber_imes
berline93716853berline_
berlins93216013berlin_s
berries94423553berri_es
betaines10313293betaines
betonies10413063betonies
brines85028853_br_ines
bromines122514253_bromines
carbines123617553carbines
carlines103521673carlines
carmines123617883carmines
cercises12410933cercises
cerises94722253cer_ises
cerites94823433cer_ites
cervices1537133cervices
cervine122610803cervine_
cervixes2054603cervixes
chemokines2193993chemokines
cherries131812993cherri_es
chlorines142512353chlorines
chorines132917253chor_ines
crones84729243_cro_nes
cronies9622513_cronies
debones103315113debo_nes
declines113315803declines
defines114118683de_fines
delaines9312963delaines
dentines93418403dentines
depones103717093depo_nes
derbies103016053derbi_es
derides93420853der_ides
derives114017813der_ives
dermises112512023dermises
derries83124623derri_es
derrises93012783derrises
destines93619663destines
devoices14307413devoices
drones75023433_dro_nes
ebonies9312883_ebonies
eeriness8311873eer_iness
eloined8149813_eloined
eloiner7149183_eloiner
eloiners8128153_eloiners
eloins65419383_eloin_s
engines81114463_engines
eosines73718293_eosines
equines161811593_equines
ermine8416923_ermine_
ermined10410603_ermined
ernes55224813_er__nes
erodes74819883_ero_des
eroses65327063_ero_ses
erotizes17311213_erotizes
errhines1136413errhines
eserines8413743eser_ines
etoiles7411293_etoiles
exines135715803_e_xines
felines104718073fe_lines
felonies11310993felonies
ferine96422583fer_ine_
ferlies103216693ferli_es
ferries103521083ferri_es
ferrites112312833ferrites
genoises939253genoises
germiness1257693germiness
gherkins1643993gherkin_s
groined92710813_groined
groins73917203_groin_s
groynes1137823_groynes
hairlines1237133hairlines
hardies114923233hardi_es
hardiness132310373hardiness
harmine122816193harmine_
harmins123716723harmin_s
harmonies141311043harmonies
harpies123818323harpi_es
harpings14379773harpings
harpins123615703harpin_s
harries103525503harri_es
headiness132510363headiness
headings133510493headings
headlines13119013headlines
hearings123611853hearings
hearties11315423hearti_es
heartiness1338033heartiness
heavies132713873heavi_es
heaviness15207063heaviness
hebraizes2344123hebraizes
hedonics1445903hedonics
heelings12359753heelings
heftiness1536313heftiness
heinies102514543he__inies
helices12313723he_lices
helixes1739133he_lixes
helpings14255653helpings
hematines141312203hematines
hemins113417573he_min_s
hemline12311073hemline_
henbanes1336583henbanes
henries102718283henri_es
heptanes1339003heptanes
herbages1437103herbages
herbier1239593herbi_er
herbiest1339993herbi_est
hercules1337633hercules
herdics13249523herdi_cs
herding122915123herdin_g
heredes11313133her_edes
herein93717793herein__
hereinto1145433hereinto
heres86245903her___es
heresies11312703heresies
heriots10312063her_iots
hermits12312143hermi_ts
herniae1039043herniae_
hernias10310773herni_as
herniates1247333herniates
herns84825583her__n_s
heroic113516923heroi__c
heroical13410023heroical
heroicizes2445293heroicizes
heroinisms1546633heroinisms
heroism12311013heroi_sm
heron85025503hero_n__
heronries1248493heronries
heronry1346043hero_nry
heros84930863hero___s
herpes115517323her__pes
herried113514473herri_ed
herring113615883herrin_g
hertzes1938303her_tzes
hessites1138613hessites
hexamines2146203hexamines
hexanes17319463he_xanes
hexone16289233hexo_ne_
hexoses17228893hexo_ses
hiplines13310593hiplines
hircine1239143hircine_
hoises94823683h__oises
homines123518653h_omines
hones88144493h__o_nes
hormones13311173hormones
horniness12309143horniness
hornings12238363hornings
horsiness12259483horsiness
hotlines11811643hotlines
hurdies114015663hurdi_es
hurlies103315333hurli_es
hurlings12388213hurlings
hurries103919653hurri_es
hyalines14169333hyalines
irones64724013_iro_nes
ironies7517423_ironies
jerkies183411583jerki_es
jerkiness20175643jerkiness
jerkins18358253jerkin_s
jerries143817513jerri_es
kermises14248313kermises
kernes104717533ker__nes
kernites1269113kernites
kerogens1345763kerogens
kerosenes1345453kerosenes
kerosine1238153kerosine_
kerries113317913kerri_es
ketones115014503keto_nes
koines10415733__koines
leones64417723le_o_nes
leucines1037273leucines
ligroines1044993ligroines
marines93928033mar_ines
marlines103818743marlines
mercies113817563merci_es
merinos9311983mer_inos
merises93421423mer_ises
merlins93015813merlin_s
merriness1138293merriness
moraines10314373moraines
murines93718223mur_ines
nerdiness10208333nerdiness
nereides938503nereides
nervine102510633nervine_
nerviness12226873nerviness
nervings12256323nervings
neurines8311193neurines
neurones839683neuro_nes
ordines83014903_ordines
oroides8311973_oroides
orpines94414793_orpines
overmines14312683overmines
pectines121914683pectines
pemolines1348623pemolines
pennines103112043pennines
peones83821043pe_o_nes
peonies93620153pe_onies
pepsines1239883pepsines
perinea9313043per_inea
perkiness15209173perkiness
perlites10316363perlites
perniones1148593perniones
peroxides1947493peroxides
perries93226603perri_es
pheromones1745633pheromones
prolines102619693_prolines
promines123018803_promines
propines122618933_propines
purines94420773pur_ines
purlines103514063purlines
pyrones123113303pyro_nes
pyronines1458323pyronines
reclines103718543reclines
recoined113614433recoined
recoins94019243recoin_s
redlines93916083redlines
refines105426343re_fines
rejoices17287663rejoices
rejoined16318593rejoined
rejoins143111383rejoin_s
relines75331323re_lines
repines94927383re_pines
reraises8415643reraises
rerises73525883rer_ises
reroutes8312223reroutes
reshines112615443reshines
retines75134673re_tines
revoices13278993revoices
rexines144719153re_xines
rezones163213943rezo_nes
sardines92815583sardines
seines65029903se__ines
sereins73716123serein_s
serenes73222903ser_enes
sergings10299213sergings
series64540973ser_i_es
serine65432673ser_ine_
serins64029673ser_in_s
serotine8313573serotine_
serotinies1047443serotinies
serries73925353serri_es
services1338573services
servings12249223servings
sestines82717243sestines
setlines8312743setlines
sherries111812903sherri_es
sherrises12156873sherrises
shrines104618693shr_ines
sordines92414073sordines
spermines13310543spermines
teredines1049453teredines
tergites9310543tergites
terminus1037393terminus
termites10313693termites
ternes65422903ter__nes
terpenes102111573terpenes
terranes82514433terranes
terrenes82212603terrenes
terries73425633terri_es
terrine72517573terrine_
thebaines1454973thebaines
theines104013233the__ines
theories11311593theori_es
theorises1247813theorises
theorizes2147073theorizes
thermites1438043thermites
threonines1344553threonines
thrones105715843thro_nes
thyroxines2343703thyroxines
trines64132563_tr_ines
trones65629283_tro_nes
tropines102214923_tropines
turbines1039903turbines
tyrosines1246863tyrosines
urines64724123_ur_ines
venines103516613ve_nines
verbiles1338923verbiles
verdins112812333verdin_s
verites103822263ver_ites
vernixes1836053vernixes
versine102515173versine_
vertices13612283vertices
wherries14179033wherri_es
xeroses143612833xero_ses
xeroxes13246443xero_xes
zebrines1935883zebrines
zeroes154314343zero__es
zeroing1738343zeroin_g

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.406440125.6
2DLD Change Limit1461623237.97018339.0
3Display Results3233230.1402307.1
 (SQL Overall)1786913238.51620983.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.