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

156 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
aclinic1118897(None) 
acinic104713541ac_inic
actinic111810551actinic
clinic104312791_clinic
acidic113612132ac_idic
acini75718982ac_ini_
acronic112814692acronic
actinia91710852actinia
albinic1136852albinic
aminic104413512a_minic
aplitic11311742aplitic
auxinic1644712auxinic
clinics11338742_clinics
clitic103315052_clitic
clonic104914672_clonic
kaolinic1444702kaolinic
aalii5316133aali_i_
aaliis6312903aali_is
ablings1038743ablings
ablins8316193ablin_s
acapnia1145913acapnia
accidia1246993accidia
accidie1247733accidie
acerbic1335643acerbic
acetic10314503ac_etic
acetonic1238733acetonic
aching126521973achin_g
acinar8310483ac_inar
acing87429153ac_in_g
acinus8311253ac_inus
acmatic13311693acmatic
acmic11312333ac__mic
aconitic1239533aconitic
acrotic112515543acrotic
acrylic1496283acrylic
actin74922553actin__
actinal9312293actinal
acting95920983actin_g
actings104512463actings
actiniae101810013actiniae
actinian10209003actinian
actinias101810843actinias
actinide11199213actinide
actinism12119883actinism
actinium1297553actinium
actinoid1148013actinoid
actinon9459463actinon
actins86321103actin_s
acyclic1345573acyclic
adipic1137263a_dipic
aeonic83517043a_eonic
agonic93515143a_gonic
ailing74331013ailin_g
alanin6317273a_lanin
albitic1139133albitic
alcaic1039983a_lcaic
alibi7514233a_libi_
alibis8311073a_libis
aline57243153a_lin_e
alined75221403a_lined
aliner65621983a_liner
alines65735223a_lines
alining81917043a_lining
allelic9118173allelic
allicin949953allicin
allylic12155843allylic
alnico877943a_l_nico
aluminic1245773aluminic
amidic114012873a_midic
ammonic1349163ammonic
amnic95516243a__mnic
amnionic1245603amnionic
anaclitic1346503anaclitic
anionic9312873anionic
anisic8313793a_nisic
aphonic142713393aphonic
arsenic939323arsenic
ascitic1139323ascitic
atonic83420473a_tonic
augitic1038283augitic
aulic74420243aul__ic
avionic1237693avionic
axenic154210003a_xenic
axonic154312723a_xonic
azonic175513153a_zonic
blini75519273_blini_
blinis85313683_blinis
bulimic1345143bulimic
calcic9311873cal_cic
calcific1445023calcific
calcitic1148193calcitic
caloric113413223caloric
canonic11312933canonic
casini84615863casini_
cationic12310013cationic
civic123412543_c_ivic
cleric10612133_cleric
clinal8311553_clinal
clinch133910353_clinch
cline76428533_clin_e
clines84926043_clines
cling86424673_clin_g
clings95716213_clings
clingy12659063_clingy
clinical1247023_clinical
clink115320043_clin_k
clinks125815063_clinks
clitics11279973_clitics
clivia1177233_clivia
colitic112916193colitic
colonic115015713colonic
conic95329793_c_onic
crisic103611843_crisic
critic103616813_critic
cyanic133110773_cyanic
cyclonic1446973cyclonic
cynic124712423_c_ynic
diactinic1443443diactinic
echini114710433echini_
ecliptic1455333ecliptic
enclitic1247513enclitic
eosinic947713eosinic
fulminic1543493fulminic
galenic1038693galenic
gasolinic1243513gasolinic
iconic10411593ic_onic
illitic939253illitic
isoclinic1343113isoclinic
laconic1139883lac_onic
lactonic1248043lactonic
limnic10418843__limnic
linac7315413__linac
linin58025523__linin
marlitic1238343marlitic
melanic11310403melanic
myelinic1544243myelinic
nucleinic1342943nucleinic
nuclidic1363563nuclidic
oceanic1146163oceanic
oolitic92512883oolitic
pacific1646913pac_ific
pelitic111814653pelitic
politic112918713politic
pollinic1247333pollinic
quinic17319473_quinic
rabbinic1443123rabbinic
rachitic1547593rachitic
scenic10510513sc_enic
selenic9410663selenic
silicic1147603silicic
splenic1148663splenic
succinic1144033succinic
tachinid1446243tachinid
triclinic1354223triclinic
vaccinia1543363vaccinia
vinic10314973__vinic

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271567.29618369.9
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.51523777.9
 
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.