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

138 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
cocreate12261181(None) 
cocreated142710091cocreated
cocreates132611881cocreates
ocreate93711741_ocreate
cochleate1645682cochleate
cocreator1346962cocreator
concrete12411082concre_te
cordate10315222co_rdate
corelate10516012co_relate
correlate1149042correlate
create85126382__create
increate10312202increate
ocreae83310272_ocrea_e
procreate1348132procreate
recreate10313602recreate
uncreate10311352uncreate
accrete1137843accre_te
acerate92818913_acerate
acreage1037843_acreage
aureate72515283_aureate
borate85026153bo_r_ate
calceate1239863calceate
carate84734003c_ar_ate
caseate9314783c_aseate
cerate84829463c_er_ate
chocolate1647403chocolate
chordate1448033chordate
cirrate92413493c_irrate
citrate92216803citr_ate
clypeate1543873clypeate
coacervate1763713coacervate
coarctate1344823coarctate
cochleae1544643cochlea_e
cockade1638133coc_kade
cockeye1867223cocke_ye
cocomat13413623cocomat_
cocomats1449403cocomats
cocotte1138603coc_otte
cocreating15310293cocreating
cocreators1447143cocreators
coequate1946153coequate
coerect11913353coerect_
coerected1447643coerected
coerects1258543coerects
cogitate1148553cogitate
cognate10312203co_gnate
cohobate1547013cohobate
coinmate1239063coinmate
collate92919683co_llate
colocate12313433colocate
comate104124843co__mate
compete134716553compe_te
comrade12139213comr_ade
concreted1439413concre_ted
concretes13411473concre_tes
conepate12712533conepate
conflate13311173conflate
congregate1445243congregate
connate9315753co_nnate
cooperate13710143cooperate
copemate1439993copemate
copulate122614113copulate
coquette1976593coquette
cordage11310063co_rdage
cordite10315263co_rdite
corelated12411823co_related
corelates11314863co_relates
corkage1438373co_rkage
cornute939643co_rnute
coronate103018213coronate
corotate102813933corotate
corrade101111043co_rrade
correct11513983correct_
corrected1438113corrected
correcter1348103correcter
corrects1259573corrects
correlated1346683correlated
correlates1248673correlates
corrugate1255483corrugate
corsage1039803co_rsage
corvette1338093corvette
costate94019273co_state
couchette1644913couchette
courage10310993cour_age
courante1049953courante
courgette1244523courgette
covariate1446213covariate
coverage1438733coverage
cowrite123612683cowr_ite
cowrote12289673cowr_ote
crate76537403__cr_ate
crease85519573__crease
created104323453__created
creates95225203__creates
cremate113816183__cremate
crenate93317113__crenate
cuneate9311723c_uneate
curate85226243c_ur_ate
curette939783c_urette
curtate9312643c_urtate
decrease1136563decrease
excrete1667163excre_te
foredate12310913fo_redate
formate123115093fo_rmate
foveate1338363fo_veate
increase1066453increase
jockette2165033jockette
lacerate102214703lacerate
laureate888023laureate
locate83919843loc__ate
loculate101011403loculate
macerate122314073macerate
miscreate1348893miscreate
moderate11710993moderate
nucleate1048673nucleate
ochreae12295083ochrea_e
ocrea73311823_ocrea__
octette946423_octette
oleate6318883_o_leate
operate9615733_operate
orate55133303_o_r_ate
ornate6315143_o_rnate
overate10620963_overate
picrate112014143picr_ate
procreated1546443procreated
procreates1448153procreates
recrate92621663recr_ate
recreated12412533recreated
recreates11313363recreates
roseate7613453ro_seate
secrete9311073secre_te
sorbate9311733so_rbate
toccate1138773toc_cate
tolerate8312323tolerate
ulcerate1039733ulcerate
uncrate9415953uncr_ate
uncreated12312303uncreated
uncreates11310433uncreates

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.453394461.4
2DLD Change Limit1461621387.73318901.1
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.24921662.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.