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

143 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
sciatic1191016(None) 
sciatica12106111sciatica
sciatics12117271sciatics
acmatic13311692acmatic
ascitic1139312asci_tic
aviatic1239242aviatic
ectatic11310122ectatic
ischiatic1644292ischiatic
sceptic1337822sceptic
sciaticas13104812sciaticas
sematic111716862sematic
sialic8313632s_ialic
somatic111916452somatic
static83118672s_tatic
viatic11311452_viatic
abiotic11510453abiotic
acetic10314503ac_etic
acidic113612133aci_dic
acidotic1355973acidotic
acinic104713543aci_nic
acrotic112515533acrotic
agnatic10310963agnatic
aquatic1838113aquatic
ascetic11310063asc_etic
astatic9514193astatic
biotic103816603_biotic
cantic103920533_cantic
chaotic14310013_chaotic
chiastic15287473chiastic
citric102812303_citric
civic123412543_ci_vic
clastic113013953_clastic
climatic1448713climatic
clitic103315053_clitic
coati75624633_coati_
coatis85122593_coatis
comatic131816923comatic
cretic102816283_cretic
critic103616813_critic
cultic105111903_cultic
cyanic133110773_cyanic
cystic132710653_cystic
deictic1237703deictic
deistic10311173deistic
dicastic1347343dicastic
dyscratic1744213dyscratic
ecliptic1455333ecliptic
ecstatic1246153ecstatic
ekistic1377843ekistic
enatic8317563_enatic
eristic9814083eristic
erratic9311113erratic
fanatic12610693fanatic
fascistic1644573fascistic
fistic11812573_fistic
hematic141816733hematic
hepatic141712773hepatic
iatric8312153__iatric
ictic9311793__ictic
idiotic1037453idiotic
iritic83213823iri_tic
ischiadic1751663ischiadic
lunatic938753lunatic
meiotic11410923meiotic
miotic103715743_miotic
nematic111713983nematic
oceanic1146163oceanic
octadic1245713octadic
osmatic11179983osmatic
otitic83112683oti_tic
phatic133014403_phatic
pianic103714123_pianic
piratic11314293piratic
priapic1346023priapic
psoatic1139303psoatic
psoriatic1387023psoriatic
quintic18308883quintic
sabbatic1445323sabbatic
saccadic1244173saccadic
sadistic1148353sadistic
salic73424713s__alic
satanic939933satanic
sati45539323s__ati_
satin55935213s__atin
satis55633673s__atis
scabietic1542893scabietic
scaldic1235943scaldic
scandic1237003scandic
scat65848373sc_at__
scathe114414993sc_athe
scats75930603sc_at_s
scatt76030093sc_at_t
scatts85914663sc_atts
scatty115310653sc_atty
scenic10510513sc_enic
sceptics1455663sceptics
schematic1847843schematic
schismatic1954633schismatic
schtick18194523sc_htick
schtik15185413sc_htik
sciaenid1153573sciaenid
sciurid1044923sciurid
scoliotic1345933scoliotic
scotia8310783sc_otia
scottie937443scottie
scraich1436763scra_ich
scrapie115010943scrapie
scratch1446013scratch
sebacic1346393sebacic
sebasic1146893sebasic
seismic1145753seismic
semantic1249553semantic
semiotic12710623semiotic
septic102713183s_eptic
seriatim1049213seriatim
shiatsu1033423shiatsu
shiatzu1942883shiatzu
shittim1245103shittim
sialid7314933s_ialid
skeptic1545193skeptic
smectic1336603smectic
solatia7312243solatia
somitic111512613somitic
sonantic1048273sonantic
soritic91414423soritic
spastic11310373spastic
spathic1437523s_pathic
statice92614033s_tatice
statics93314533s_tatics
statin63921463s_tatin
stearic939423stearic
stichic1446243stichic
stigmatic1445713stigmatic
stomatic12311983stomatic
strati63518893strati_
styptic1445443styptic
sylvatic1645353sylvatic
synaptic1546283synaptic
triadic1037823triadic
uratic83016353_uratic
vatic10316423__vatic
venatic12311523venatic
viatica1245863_viatica

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271438.75015317.4
3Display Results1431430.0463108.7
 (SQL Overall)1786911438.95219961.0
 
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.