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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
keramic153723(None) 
ceramic1339821ceramic
keramics1644821keramics
ceramics1446802ceramics
dermic114511912der_mic
karmic1438112kar_mic
keratin113314152keratin
kermis124012392ker_mis
aerobic11310213aerobic
agamic113110563_agamic
agravic1345893agravic
apraxic1846293apraxic
arabic10312733_arabic
aramid93315613_aramid
boracic1338723boracic
bromic122412693_bromic
carbamic1645913carbamic
ceramal1138843ceramal
ceramide1347973ceramide
ceramist12310933ceramist
ceratin93020163ceratin
ceric94023093cer__ic
cerotic11415063cerotic
chromic1639863chromic
degami10279013degami_
degamis11268443degamis
demic105119193de__mic
derail74218813dera_il
dermis94717163der_mis
dharmic1535013dharmic
dioramic1346763dioramic
dynamic1545813dynamic
emic86422753_e__mic
enatic8317563_enatic
erotic82620273_erotic
erratic9311113erratic
etamin81311853_etamin
faradic1337693faradic
fermi103914163fer_mi_
fermis114313503fer_mis
ferric1139993fer_ric
formic13310453for_mic
gamic103916203__gamic
genomic1237923genomic
germanic1367503germanic
hematic141816743hematic
hemic125718623he__mic
hepatic141712773hepatic
heraldic1445163heraldic
herdic123112303her_dic
heretic12314833heretic
hermai118912863hermai_
hermit11519443her_mit
heroic113516923her_oic
hexadic2045413hexadic
hieratic1349223hieratic
kami105823643k__ami_
kamik105011553k__amik
karstic1357983karstic
kenotic1359713kenotic
keratins122313483keratins
keratoid1347273keratoid
keratosic1544503keratosic
keratotic1545643keratotic
kermes124616123ker_mes
kerria10339913ker_ria
ketamine14157053ketamine
ketonic1349923ketonic
ketotic1348643ketotic
korai97018523kora_i_
krait94726773k_ra_it
lexemic1844283lexemic
marasmic1446163marasmic
melanic11310403melanic
mermaid1297853mermaid
meropic13310263meropic
nematic111713993nematic
neritic91314333neritic
neumic1036853ne_umic
oghamic1544043oghamic
operatic1249933operatic
pelagic1237863pelagic
peracid12312993peracid
permit10321683per_mit
piratic11314293piratic
potamic13310853potamic
puranic11410483puranic
pyramid1547513pyramid
rabic93817403__rabic
rami66034093__rami_
ramie75027823__ramie
rearmice1255213rearmice
reremice1246023reremice
sebacic1346393sebacic
sebasic1146893sebasic
seismic1145753seismic
sematic111716873sematic
sememic1336503sememic
serac75925203sera__c
serai56830163sera_i_
serail64222673sera_il
serais64326133sera_is
seraphic1546633seraphic
spermic1338523sper_mic
telomic1147603telomic
terai53525483tera_i_
terais64023513tera_is
terbic10410963ter_bic
terebic1137983terebic
tetanic9810133tetanic
tetradic1145813tetradic
thermic1439333ther_mic
tragic93811543_tragic
uraemic1156543_uraemic
uranic82315183_uranic
uratic83016353_uratic
uremic103410513_uremic
venatic12311523venatic
veridic1338143veridic
vermin113414523ver_min
vermis114214963ver_mis
viremic1436153viremic
xeric144315663xer__ic
xerotic16410863xerotic
zebraic2044293zebra_ic

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271256.09321996.9
3Display Results1251250.0333787.9
 (SQL Overall)1786911256.54927285.2
 
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.