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

165 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
corelates1131486(None) 
corelate10516011corelate_
corelated12411821corelated
correlates1248671correlates
chelates132713842c_helates
cocreates132611882cocre_ates
collates103019142co_llates
conepates13912282conepates
conflates14311132conflates
copemates1549482copemates
copulates132612462copulates
coronates1110816922coronates
corotates112714282corotates
correlate1149042correlate_
correlated1346682correlated
creates95225202c_re_ates
cremates124216002c_remates
foredates13310052foredates
prelates10418572_prelates
relates73731432__relates
acrylates1446683acrylates
borates94823013bor__ates
boreases10310253bore_ases
canulates11312873canulates
carates95630613car__ates
caretakes1547143caretakes
caseates10313713case_ates
casemates1349523casemates
catenates11311813catenates
cerates95428253c__erates
cerebrates1447913cerebrates
cervelases1542933cervelases
cervelats1443493cervelat_s
chelate122914893c_helate_
chelated142610483c_helated
chocolates1746783chocolates
cholates132414763c_holates
chordates1547683chor_dates
chromates16313113chromates
circulates1489283circulates
coagulates13137453coagulates
cocreate122611813cocre_ate_
cocreated142710093cocre_ated
coelomates1497573co_elomates
coelomes1239293co_elomes
coequates2045853coequates
coesites101313093co_esites
cogitates1247863cogitates
cognates11311583co_gnates
cohobates1646523cohobates
coinmates1348343coinmates
collages113514243co_llages
collate92919683co_llate_
collated113615063co_llated
colocates13312853colocates
comates114123643co__mates
completes153212923completes
conclaves1646543conclaves
conepate12712533conepate_
conepatls1385343conepatls
conflate13311173conflate_
conflated1539333conflated
congregates1545503congregates
consulates12711103consulates
cooperates1469613cooperates
copemate1439993copemate_
coprolites1448223coprolites
copulate122614113copulate_
copulated142710483copulated
cordages12310113cor_dages
cordate10315223cor_date_
cordelles1248233cordel_les
cordites11314623cor_dites
corelating13511583corelating
coreless103013833corel_ess
corkages1539103cor_kages
corncakes1745013corncakes
cornflakes1942573cornflakes
corollate1148123corollate_
coronate103018213coronate_
coronated123313323coronated
corotate102813933corotate_
corotated122810053corotated
corporates14410733corporates
corrades111211263cor_rades
correlatives1753903correlatives
correlator1245693correlator
correlators1345593correlators
corrugates1345183corrugates
corsages11310363cor_sages
corselets1147313corselet_s
corselettes1352993corselettes
corslets1038273corslet_s
coruscates1445683coruscates
corvettes1447433corvettes
corybantes1743913corybantes
covellites1554713covellites
coverages1538833coverages
cozenages2194693cozenages
crates85736063c_r__ates
creases94020963c_re_ases
create85126383c_re_ate_
created104323453c_re_ated
cremate113816183c_remate_
cremated133412963c_remated
crenate93317113c_renate_
crenated113013913c_renated
crenelates1266193crenelates
crewmates16375803c_rewmates
cumulates13258973cumulates
curates95323833cur__ates
curettes1039313cure_ttes
delates83526283__delates
doorplates1343933doorplates
elates65032363___elates
folates103218453fo__lates
foredate12310913foredate_
foredated1447683foredated
forefaces1747133forefaces
foreladies1444983foreladies
forelands1347173forelands
forenames1447543forenames
foretastes1375593foretastes
formates132814293for_mates
formulates1546543formulates
gelates83219583__gelates
loricates11310123loricates
misrelates1247623misrelates
moderates12710753moderates
modulates1238053modulates
morelles10710493morel_les
oblates91913243_o_blates
ocreate93711743ocre_ate_
oleates7417833_ole_ates
operates10515413_operates
orates64328613_or__ates
ovulates1148523_ovulates
oxalates1557063_oxalates
populates132710673populates
predates11615813_predates
prelate9519693_prelate_
rebates95123183__rebates
redates83423873__redates
reflates113115663__reflates
regelates10311113regelates
relaces93420883__relaces
relate64033633__relate_
related83327573__related
relater73723143__relater
relaters83218153__relaters
relaxes143215323__relaxes
remates93827113__remates
replates102919273__replates
reslates83619503__reslates
solates73523853so__lates
soleplates1244973soleplates
sorbates10311103sor_bates
sororates9410473sororates
sporulates1246483sporulates
toeplates1147183toeplates
tolerates9312123tolerates
unrelated10310433unrelated
vorlages1236033vor_lages
workmates1845003workmates
yokemates1844193yokemates

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411657.78019105.5
3Display Results1651650.0632619.0
 (SQL Overall)1786911658.26621617.6
 
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.