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

60 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
keramics164482(None) 
ceramics1446801ceramics
keramic1537231keramic_
ceramic1339822ceramic_
keratins122313482keratins
kermis124012392ker_mi_s
aerobics1246833aerobics
aramids102810513_aramids
ceramals1246513ceramals
ceramicist1655583ceramicist
ceramide1347973ceramide
ceramides1447453ceramides
ceramist12310933ceramist
ceramists1346723ceramists
ceratins102818733ceratins
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
kamiks11387913k__amiks
karmic1438113kar_mic_
keratin113314153kerati_n
keratitis1345873keratitis
kermes124616123ker_m_es
kermess13396223ker_mess
kermises14248313ker_mises
kerrias11289513ker_rias
kerries113317913ker_ries
ketamine14157053ketamine
ketamines15177033ketamines
kraits104912203k_ra_its
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.1701051123.5
2DLD Change Limit146162607.90618487.5
3Display Results60600.0331818.2
 (SQL Overall)178691608.10922036.1
 
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.