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

155 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
corelated1241182(None) 
corelate10516011corelate_
corelates11314861corelates
correlated1346681correlated
chelated142610492c_helated
cocreated142710092cocre_ated
collated113615062co_llated
conflated1539332conflated
copulated142710482copulated
coronated123313322coronated
corotated122810052corotated
correlate1149042correlate_
correlates1248672correlates
created104323452c_re_ated
cremated133412962c_remated
crenated113013912c_renated
foredated1447682foredated
related83327572__related
unrelated10310442unrelated
areolated1089723_areolated
belated103520013__belated
borated104116363bor__ated
canulated12310673canulated
carinated123414273carinated
caseated11310713case_ated
casemated1446953casemated
catenated1238923catenated
caveated1439133cave_ated
cerated103922473c__erated
cerebrated1546343cerebrated
cheated134416343c_he_ated
chelate122914903c_helate_
chelates132713853c_helates
circulated1588063circulated
cleated103417843c_le_ated
coagulated1496533coagulated
coated94927043co___ated
cocreate122611813cocre_ate_
cocreates132611883cocre_ates
coedited1237833co_edited
coempted1535333co_empted
coenacted1445803co_enacted
coequated2144823coequated
coerected1447643coerected
cogitated1346323cogitated
coheaded1536603cohe_aded
cohobated1744883cohobated
collaged12279973co_llaged
collared113211143co_llared
collate92919683co_llate_
collates103019143co_llates
collected1447973collected
colleted113011663co_lleted
colocated1439613colocated
combated1539823co_mbated
completed162810273completed
conepate12712533conepate_
conepates13912283conepates
conflate13311173conflate_
conflates14311133conflates
congregated1644733congregated
cooperated1567333cooperated
copemate1439993copemate_
copemates1549483copemates
copulate122614113copulate_
copulates132612463copulates
corbeled1338373corbel__ed
corbelled1446613corbel_led
cordate10315223cor_date_
cordelled1346403cordel_led
corelating13511583corelating
cornuted1137473cor_nuted
corollate1148123corollate_
coronate103018213coronate_
coronates1110816923coronates
coroneted12278323coroneted
corotate102813933corotate_
corotates112714283corotates
corraded12128293cor_raded
corralled1245283corralled
corrected1438123corrected
correlator1245693correlator
corrugated1444433corrugated
corrupted1444503corrupted
corseted11311473cor_seted
coruscated1544473coruscated
covenanted1663803covenanted
coveted133011523cove__ted
crated94827773c_r__ated
creaked143413233c_re_aked
creamed123913713c_re_amed
creased104315593c_re_ased
create85126383c_re_ate_
creates95225203c_re_ates
credited1238253c_redited
cremate113816183c_remate_
cremates124216003c_remates
crenate93317113c_renate_
crenelated1375363crenelated
crenulated1356043c_renulated
crested103416543c_re_sted
cumulated14237843cumulated
cuneated11310103cune_ated
curated104717583cur__ated
curetted1137173cure_tted
delated93722873__delated
disrelated1247343disrelated
elated74725823___elated
floreated1346573flore_ated
forecasted1685113forecasted
foredate12310913foredate_
foredates13310053foredates
foreland1239013forela_nd
forenamed1545163forenamed
forested12312463fore_sted
foretasted1484753foretasted
formulated1645563formulated
foveated1536293fove_ated
gelated93615643__gelated
lobulated12106423lobulated
loculated1288313loculated
loricated1247903loricated
misrelated1346493misrelated
moderated1388143moderated
modulated1336713modulated
ocellated1245453ocellated
ocreate93711743ocre_ate_
operated11512223_operated
orated74221503_or__ated
ovulated1237083_ovulated
oxalated1695323_oxalated
populated14228803populated
predated12513273_predated
prelate9519693_prelate_
prelates10418573_prelates
rebated103619703__rebated
redated93120923__redated
reflated123514293__reflated
regelated1139723regelated
relaced103517213__relaced
relate64033633__relate_
relater73723143__relater
relates73731433__relates
relaxed153312533__relaxed
relayed113212753__relayed
remated103522473__remated
replated112817523__replated
reslated93517523__reslated
solated83618023so__lated
sporulated1345263sporulated
threated1259203thre_ated
tolerated1049123tolerated
treated83618703_tre_ated
uncorrelated1553393uncorrelated
unrelaxed1744473unrelaxed

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411556.89021573.4
3Display Results1551550.0801937.5
 (SQL Overall)1786911557.39324170.3
 
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.