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

85 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
ceramides144745(None) 
ceramide1347971ceramide_
acetamides1543602acetamides
carbamides1745132carbamides
ceramics1446802cerami_cs
ceramists1346722ceramists
chromides1747602chromides
acetamide1443753acetamide_
acetamids1443443acetamid_s
amides95722663___amides
aramids102810513_aramid_s
bromides13219363_bromides
calamines13312223calamines
calamites13410713calamites
camises114218463c__amises
carabids1338193carabid_s
carabines13311473carabines
carbamide1645743carbamide_
carbides133111693car_bides
carmines123617873car_mines
caryatides1644493caryatides
catamites1349363catamites
ceramals1246513ceram_als
ceramic1339823cerami__c
ceramicist1655583ceramicist
ceramist12310933cerami_st
cerastes101111093cera_stes
cerates95428253cera__tes
ceratins102818733cerati_ns
ceratodus1243223ceratodus
cercises12410933cer_cises
cerises94722253cer__ises
cerites94823433cer__ites
cerusites1146523cerusites
cervices1537133cer_vices
cervixes2054603cer_vixes
chamades16138653c_hamades
chamises153513313c_hamises
chlamydes2062293chlamydes
chromide1648053chromide_
chromites16310963chromites
chromizes2547603chromizes
crambes1339963c_ram_bes
cramboes1436543c_ramboes
crazies183413853c_razi_es
creamier12319063creami_er
creamiest13248933creami_est
creaminess1446203creaminess
creatines112814433creatines
creatives14279693creatives
curacies12311763curaci_es
curarines11710553curarines
curarizes2078173curarizes
curatives1437823curatives
curbsides1444483curbsides
cyanamides1842953cyanamides
cyanides14258003c_yanides
derides93420853der__ides
dermises112512023der_mises
diamides1238823_diamides
enamines101112133_enamines
eremites10312603_eremites
ermines9416673_er_mines
etamines101611813_etamines
examines17128793_examines
formamides1843873formamides
hexamines2146203hexamines
keramics1644823kerami_cs
kermises14248313ker_mises
ketamines15177033ketamines
melamines1339763melamines
mermaids1355753mermaid_s
nearsides1044523nearsides
nereides938503ner_eides
peracids13310073peracid_s
peroxides1947493peroxides
pyramided1873833pyramided
pyramids1645643pyramid_s
ramies84630463__rami_es
reraises8415643rera_ises
seasides938743se_asides
sodamides1344653sodamides
termites10313693ter_mites
tyramines1447213tyramines
uranides92211283_uranides

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.440406115.9
2DLD Change Limit148641857.25020502.2
3Display Results85850.0302833.3
 (SQL Overall)178691857.72023146.5
 
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.