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 “cosmetic” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

66 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
cosmetic144778(None) 
cometic131215721co_metic
cosmetics1545461cosmetics
comatic131816932co_matic
comedic14158632co_medic
cosmic12410342cosm__ic
kismetic1644882kismetic
osmatic11179982_osmatic
osmotic11127612_osmotic
anosmatic1347733anosmatic
ascetic11310063_ascetic
caseic103212373cas_e_ic
chimeric1746743chimeric
climatic1448723climatic
cobaltic1455913cobaltic
colitic112916193co_litic
comatik15139723co_matik
comet95946073co_met__
cometh134811683co_met_h
comets105823583co_met_s
comic114721813co_m__ic
comitia1139723co_mitia
copacetic1454633copacetic
copasetic1554423copasetic
copesetic1554413copesetic
copremic1645453copremic
cosec96320183cos_e__c
coset75748843cos_et__
cosets85824403cos_et_s
cosmetician1753933cosmetician
cosmeticize2652883cosmeticize
cosmid11810643cosm__id
cosmogenic1754103cosmogenic
cosset84125863cosset__
cosseted1178343cosseted
cosseting1239543cosseting
cossets95014283cosset_s
coumaric1446173coumaric
cretic102816283c__retic
cystic132710653cys__tic
docetic1239913do_cetic
dogmatic1447623dogmatic
dolmenic1344843dolmenic
domestic1347813do_mestic
dosimetric1554473dosimetric
emetic10614453__emetic
exosmotic2043423exosmotic
gametic1239993_gametic
hermetic15310243hermetic
homeotic1548283ho_meotic
homeric14312213ho_meric
isomeric1247753isomeric
isometric1347893isometric
isosmotic1343653isosmotic
mesmeric1445813mesmeric
mimetic1338653_mimetic
noetic8514043no__etic
nonmetric1348063nonmetric
osmic939913_osm__ic
osteitic1046943_osteitic
poetic10416843po__etic
smectic1336613__smectic
somatic111916463so_matic
somitic111512633so_mitic
tonetic9313433to_netic
zoometric2246623zoometric

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.513348325.5
2DLD Change Limit146162667.75018859.6
3Display Results66660.0332000.0
 (SQL Overall)178691668.29621539.4
 
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.