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

174 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
heroizes20261098(None) 
heroines112916571heroines
heroize193210961heroize_
heroized21298451heroized
erotizes17311212_erotizes
hebraizes2344112hebraizes
heroes94923822hero__es
heroicizes2445292heroicizes
heroics122912002heroi_cs
heroine103517482heroine_
heroins103518012heroi_ns
heroisms1338692heroisms
herries104025072herri_es
hertzes1938302her_tzes
theorizes2147072theorizes
aeries64737783aer_i_es
aerobes9311493aero_bes
aerolites9312583aerolites
berimes115216643ber_imes
berlines102315453berlines
berries94423553berri_es
braizes183112453_braizes
bromizes21258333_bromizes
bronzes183510403_bronzes
cercises12410933cercises
cerises94722253cer_ises
cerites94823433cer_ites
cervices1537133cervices
cervixes2054603cervixes
cherries131812983cherri_es
chromizes2547603chromizes
creolizes2056583creolizes
crozes174417663_cro_zes
deionizes1958213deionizes
demonizes21311063demonizes
derbies103016053derbi_es
derides93420853der_ides
derives114017813der_ives
dermises112512023dermises
derries83124623derri_es
derrises93012783derrises
devoices14307413devoices
ebonizes1938073_ebonizes
energizes1945473energizes
ermines9416673_ermines
erodes74819883_ero_des
eroses65327053_ero_ses
erotize16311663_erotize_
erotized1838553_erotized
eternizes18118013eternizes
etherizes2149313ether_izes
etoiles7411293_etoiles
ferlies103216693ferli_es
ferries103521083ferri_es
ferrites112312833ferrites
frizes184015463_fr_izes
genoises939253genoises
ghettoizes2351563ghettoizes
grecizes2035683grecizes
hafizes2235983h_afizes
hardies114923233hardi_es
harmines132715143harmines
harmonizes24147593harmonizes
harpies123818313harpi_es
harries103525493harri_es
hearties11315413hearti_es
heavies132713873heavi_es
hebraize2244453hebraize_
hebraized2443953hebraized
heezes184211643he__ezes
heinies102514543heini_es
helices12313723he_lices
helixes1739133he_lixes
hemlines13310623hemlines
hemolyzes2664623hemolyzes
henries102718283henri_es
hepatizes2347823hepatizes
herbages1437093herbages
herbier1239593herbi_er
herbiest1339993herbi_est
hercules1337633hercules
herdics13249523herdi_cs
heredes11313133her_edes
heres86245903her___es
heresies11312693heresies
heriots10312063her_iots
hermits12312143hermi_ts
herniae1039043herniae_
hernias10310773herni_as
herniates1247333herniates
heroic113516923heroi__c
heroical13410023heroical
heroicize2345363heroicize_
heroicized2544163heroicized
heroin94420593heroi__n
heroinism1446873heroinism
heroism12311013heroi_sm
heroizing2248493heroizing
heronries1248483heronries
herons94820543hero__ns
heros84930863hero___s
herpes115517323her__pes
herried113514453herri_ed
herrings12379533herrings
hessites1138613hessites
hexones17299143hexo_nes
hexoses17228883hexo_ses
hoises94823673h__oises
hurdies114015663hurdi_es
hurlies103315333hurli_es
hurries103919653hurri_es
ironizes17510373_ironizes
jarovizes2843993jarovizes
jerkies183411583jerki_es
jerries143817513jerri_es
kermises14248313kermises
kernites1269113kernites
kerosines1357103kerosines
kerries113317913kerri_es
melodizes2146753melodizes
memorizes221310823memorizes
mercies113817563merci_es
merises93421423mer_ises
necrotizes2146173necrotizes
nereides938503nereides
nervines112310463nervines
odorizes1837213odorizes
oroides8311973_oroides
oversizes211111613oversizes
pectizes21229793pectizes
peptizes21269853peptizes
perlites10316363perlites
peroxides1947493peroxides
perries93226603perri_es
prizes173819813_pr_izes
pyrolizes2347233pyrolizes
realizes173116843realizes
rejoices17287663rejoices
reraises8415643reraises
rerises73525883rer_ises
reroutes8312223reroutes
reseizes1759853reseizes
resizes164216843re_sizes
revoices13278993revoices
seizes154317533se__izes
series64540973ser_i_es
serines74229543ser_ines
sermonizes21148363sermonizes
serotines9312073serotines
serries73925353serri_es
services1338573services
sherries111812893sherri_es
sherrises12156863sherrises
tergites9310543tergites
termites10313693termites
terries73425633terri_es
terrines82117553terrines
terrorizes1987063terrorizes
theories11311593theori_es
theorises1247813theorises
theorize2047073theorize_
theorized2245803theorized
theorizer2144863theorizer
theorizers2243333theorizers
thermites1438043thermites
verbiles1338923verbiles
verites103822263ver_ites
vernixes1836053vernixes
versines112213823versines
vertices13612283vertices
wherries14179023wherri_es
xeroses143612823xero_ses
xeroxes13246443xero_xes
zeroes154314343zero__es

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.436409841.7
2DLD Change Limit1461621747.12320519.7
3Display Results1741740.0632761.9
 (SQL Overall)1786911747.62223444.1
 
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.