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

106 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
copemate143999(None) 
copemates1549481copemates
casemate1239842casemate
coinmate1239062coinmate
comate104124842co__mate
conepate12712532conepate
cooperate13710142cooperate
copulate122614112copulate
corelate10516012corelate
cremate113816182c_remate
operate9615732_operate
yokemate1744312yokemate
agemate101210583_agemate
asperate10312373asperate
capitate121712183capitate
caseate9314783case_ate
casemated1446953casemated
casemates1349523casemates
catenate10312833catenate
cellmate1237873cellmate
cerate84829463c__erate
chelate122914903c_helate
chromate15312783chromate
climate11312833c_limate
clypeate1543873clype_ate
cocomat13413623cocomat_
cocomats1449403cocomats
cocreate122611813cocreate
coelomate1398113coelomate
coempt12311033co_empt_
coempted1535333co_empted
coempts1335683co_empts
coequate1946153coequate
coesite9713623co_esite
cogitate1148553cogitate
cognate10312203co_gnate
cohobate1547013cohobate
coinmates1348343coinmates
colemanite1445263colemanite
collate92919683co_llate
collimate1348173collimate
colocate12313443colocate
comade114415323co__made
comae97128423co__ma_e
comake144413423co__make
comates114123643co__mates
commata1338483co_mmata
commute134310443co_mmute
compensate1646143compensate
compete134716553compe__te
comte96125473co__m_te
conepates13912283conepates
conepatl1286703conepatl
conflate13311173conflate
connate9315753co_nnate
cooperage1465263cooperage
cooperated1567333cooperated
cooperates1469613cooperates
copulae112810613copula_e
copulated142710483copulated
copulates132612463copulates
copycat1647593copycat_
copycats1745083copycats
cordate10315223co_rdate
corelated12411823corelated
corelates11314863corelates
coronate103018213coronate
corotate102813933corotate
corporate13410903corporate
correlate1149043correlate
costate94019273co_state
coverage1438733coverage
cozenage2094793cozenage
create85126383c_re_ate
cremated133412963c_remated
cremates124216003c_remates
crenate93317113c_renate
crewmate15405633crewmate
cuneate9311723cune_ate
cupulate122810033cupulate
foredate12310913foredate
formate123115093fo_rmate
foveate1338363fove_ate
homemade1645153homemade
housemate1445953housemate
moderate11710993moderate
ocreate93711743ocre_ate
oleate6318883_ole_ate
operated11512223_operated
operates10515413_operates
opiate8513463_op_iate
overate10620963_overate
pedate93117763__pedate
populate122812093populate
racemate1239063racemate
remate84428683__remate
reoperate11410183reoperate
roommate1244863roommate
roseate7613453rose_ate
scopulate1366543scopulate
soulmate1047193soulmate
toeplate1047613toeplate
tolerate8312323tolerate
totemite1046873totemite
workmate1744673workmate
yokemates1844193yokemates

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.423422437.4
2DLD Change Limit1461621066.92321112.5
3Display Results1061060.0432465.1
 (SQL Overall)1786911067.38924183.4
 
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.