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 “ceramics” 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
ceramics144680(None) 
ceramic1339821ceramic_
keramics1644821keramics
ceramals1246512ceramals
ceramicist1655582ceramicist
ceramide1347972ceramide
ceramides1447452ceramides
ceramist12310932ceramist
ceramists1346722ceramists
ceratins102818732ceratins
keramic1537232keramic_
acetamids1443443acetamids
aerobics1246833aerobics
aramids102810513_aramids
carabids1338193carabids
carabins12312363carabins
caramels1238803caramels
carbamic1645913carbamic_
ceramal1138843ceram_al
ceramicists1753873ceramicists
cerastes101111093cerastes
cerates95428253cera_tes
ceratin93020163cerati_n
cercarias1346883cercarias
cercis104614493cer_ci_s
cerias83321983cer__ias
ceric94023093cer__ic_
cermets1139713cer_mets
cerotic11415063cerotic_
cerumens1235763cerumens
cervices1537133cer_vices
chemics16349583c_hemics
chromic1639863chromic_
chronics1538683chronics
chymics19295533c_hymics
clerics1149333cler__ics
comics124015563c__omics
crambes1339963c_rambes
crambos1336783c_rambos
crampits1436273c_rampits
cramps125615563c_ram_ps
crams96229153c_ram__s
crasis85020473c_rasi_s
crazies183413853c_razies
creamers124111313creamers
creamier12319063creamier
creamiest13248933creamiest
creamily1536363creamily
creaming133413143creaming
creams104715253cream__s
creatins103617513creatins
cremains1238693cremains
cretics112911653c_retics
critics112811093c_ritics
curacies12311763curacies
curaris94114773curari_s
degamis11268443degami_s
derails84216393dera_ils
dermic114511913der_mic_
dermis94717163der_mi_s
dynamics1644093dynamics
erotics91914153_erotics
erratics1046983erratics
etamins91511833_etamins
fermis114313503fer_mi_s
genomics1345713genomics
hematics151712193hematics
hepatics15198933hepatics
herdics13249523her_dics
heretics13310503heretics
hermits12312143her_mits
heroics122912003her_oics
keratins122313483keratins
kermis124012393ker_mi_s
melanics1237733melanics
mermaids1355753mermaids
operatics1346953operatics
pelagics1345553pelagics
peracids13310073peracids
permits11314003per_mits
pyramids1645643pyramids
ramies84630463__ramies
rearmice1255213rearmice
reremice1246023reremice
seracs84418573sera__cs
serails73318363sera_ils
serais64326133sera_i_s
terais64023513tera_i_s
tetanics10127373tetanics
tragics10338083_tragics
vermis114214963ver_mi_s

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.436409841.7
2DLD Change Limit146162917.68619016.7
3Display Results91910.0332757.6
 (SQL Overall)178691918.15521911.8
 
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.