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

91 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
ceramide134797(None) 
ceramides1447451ceramides
acetamide1443752acetamide
carbamide1645742carbamide
ceramic1339822cerami_c
ceramics1446802ceramics
ceramist12310932ceramist
chromide1648052chromide
acetamid1344793acetamid_
acetamides1543603acetamides
acetamids1443443acetamids
amide86128483___amide
aramid93315613_aramid_
aramids102810513_aramids
bromide12269583_bromide
calamine12314033calamine
calamite12312533calamite
camise103319633c__amise
carabid12311333carabid_
carabids1338193carabids
carabine12412393carabine
carbamides1745133carbamides
carbide126112493car_bide
carmine112918483car_mine
catamite12510593catamite
ceramal1138843ceram_al
ceramals1246513ceramals
ceramists1346723ceramists
cerate84829463cera__te
cerated103922473cerated_
ceratin93020163cerati_n
ceratins102818733ceratins
ceratoid1149923ceratoid_
cercariae1345703cercariae
cerise84822043cer__ise
cerite84724873cer__ite
cerusite1047763cerusite
cervid1239323cer_vid_
cervine122610803cer_vine
chamade15138453c_hamade
chamise143612853c_hamise
chromides1747603chromides
chromite15310833chromite
chromize2447683chromize
crambe1239073c_ram_be
crammed143710123c_rammed
cramped144712183c_ramped
creamed123913713creamed_
creamier12319063creamier
creamily1536363creamily
creaming133413143creaming
creatine103417413creatine
creative132812803creative
crimine112413473c_rimine
curarine10610713curarine
curarize1988853curarize
curative13310403curative
curbside1344673curbside
cyanamide1743343cyanamide
cyanide13298843c_yanide
deride84420033der__ide
diamide1138473_diamide
enamine91214313_enamine
eremite9312833_eremite
ermine8416923_er_mine
etamine91313073_etamine
examine161510033_examine
formamide1744403formamide
hexamine2046873hexamine
keramic1537233kerami_c
keramics1644823keramics
ketamine14157053ketamine
melamine12310303melamine
mermaid1297853mermaid_
mermaids1355753mermaids
nearside944923nearside
peracid12312993peracid_
peracids13310073peracids
peroxide1848193peroxide
pyramid1547513pyramid_
pyramided1873833pyramided
pyramids1645643pyramids
ramie75027823__rami_e
rearmice1255213rearmice
reraise7316313rera_ise
reremice1246023reremice
seaside839693se_aside
sodamide1245453sodamide
termite9313893ter_mite
tyramine1347303tyramine
uranide82212093_uranide

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.420425454.8
2DLD Change Limit146162917.72018932.9
3Display Results91910.0332757.6
 (SQL Overall)178691918.17321863.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.