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

148 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
ascitic113932(None) 
ascetic11310061ascetic
acetic10314502a_cetic
acidic113612132a_cidic
acinic104713542a_cinic
albitic1139132albitic
aplitic11311742aplitic
arctic10313512arc_tic
ascetics1247072ascetics
ascidia1046672ascidia
ascites9312602ascites
aseptic1137372aseptic
astatic9514192astatic
augitic1038282augitic
calcitic1148182calcitic
fascistic1644582fascistic
fascitis1346012fascitis
mastitic1248262mastitic
sciatic11910162_sciatic
abiotic11510453abiotic
abscisin1243973abscisin
accidia1246983accidia
accidie1247733accidie
acetin8314693a_cetin
acidotic1355983a_cidotic
acini75718983a_cini_
aclinic11188973aclinic
acmatic13311693acmatic
acmic11312333a_c_mic
aconitic1239523aconitic
acrotic112515533acrotic
actin74922553a_c_tin
actinic111810553actinic
adipic1137263a_dipic
aecidia1047273aecidia
agnatic10310963agnatic
albinic1136853albinic
alcaic1039983alc_aic
aloetic9313183aloetic
amidic114012863a_midic
aminic104413513a_minic
amniotic1246403amniotic
anaclitic1346503anaclitic
anisic8313793a_nisic
antic75728863a__ntic
aoristic10311163aoristic
aortic8316613a_ortic
aphetic142912853aphetic
aphotic142913113aphotic
aprotic112715233aprotic
aquatic1838113aquatic
archaic1438823archaic
arctics1138953arc_tics
argotic10310273argotic
artistic10310893artistic
asbestic1245383asbestic
ascarid103910713ascarid
ascaris93613323ascaris
ascesis938373ascesis
ascetical1346273ascetical
asci66519143asc__i_
ascidian1145623ascidian
ascidium1344813ascidium
ascorbic1443333ascorbic
ascot76522513ascot__
ascots85312513ascot_s
asdic83814093as__dic
aspic95114733as__pic
aspirin937823aspirin
astir55517093as__tir
atactic11410083atactic
atretic9313923atretic
attic75618353a__ttic
autistic10310103autistic
auxetic1637143auxetic
auxinic1644713auxinic
aviatic1239243aviatic
azotic172711623a_zotic
basaltic1245153basaltic
basilic1137493bas_ilic
bauxitic1943623bauxitic
calcific1445023calcific
carditic1348693carditic
casuistic1344943casuistic
citric102812303__citric
civic123412543__civic
clitic103315053_clitic
colitic112916183colitic
critic103616813_critic
deictic1237703deictic
docetic1239913docetic
dunitic1048143dunitic
enclitic1247513enclitic
eucritic1247133eucritic
fasciitis1443543fasciitis
gastritic1245323gastritic
hectic132311513hec_tic
ictic9311803_ic_tic
illitic939253illitic
iritic83213823_iritic
ischiatic1644293ischiatic
jaditic1746693jaditic
jesuitic1743383jesuitic
lactic10713493lac_tic
leucitic1245233leucitic
mannitic1248013mannitic
marlitic1238343marlitic
mastic103119173mas__tic
mastitis1039103mastitis
mycotic1647693mycotic
narcistic1346443narcistic
narcotic1277913narcotic
nastic82915973nas__tic
neritic91314333neritic
noritic91213543noritic
oolitic92512883oolitic
ophitic1439213ophitic
orchitic1546293orchitic
osmatic11179983osmatic
osmotic11127603osmotic
ossific1243103ossific
osteitic1046943osteitic
otitic83112683_otitic
pacific1646913pacific
pectic122913873pec_tic
pelitic111814653pelitic
picritic1448263picritic
poditic122611573poditic
politic112918713politic
psoatic1139303psoatic
pyritic143311313pyritic
rachitic1547593rachitic
sadistic1148363sadistic
satiric939243satiric
scenic10510513_scenic
sceptic1337823_sceptic
schtick18194523_schtick
schtik15185413_schtik
sciatica12106113_sciatica
sciatics12117273_sciatics
scotia8310783_scotia
septic102713183_septic
somitic111512613somitic
soritic91414423soritic
static83118673_static
tactic10612753tac_tic
taxitic1637093taxitic
uveitic1244683uveitic

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.1561145455.1
2DLD Change Limit1340271486.62620227.4
3Display Results1481480.0463217.4
 (SQL Overall)1786911486.82826170.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.