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 “periotic” 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
periotic1231344(None) 
peridotic1446481peridotic
periodic1348431periodic
aperiodic1444072aperiodic
cerotic11415062cer_otic
ergotic1049722_ergotic
eristic9814092_eristic
erotic82620272_er_otic
meiotic11410932me_iotic
meristic12311252meristic
neritic91314332neri_tic
parotic112518042par_otic
patriotic13107592patriotic
pelitic111814652peli_tic
pericopic1745542pericopic
periodid1248162periodid
periti8319952peri_ti_
perlitic12310582perlitic
prebiotic1545412prebiotic
puristic1239382puristic
pyritic143311312pyri_tic
semiotic12710632semiotic
veristic1339882veristic
xerotic16410862xer_otic
abiotic11510463_abiotic
acrotic112515543acr_otic
aerobic11310213aer_obic
amniotic1246403amniotic
aoristic10311163aoristic
aperitif1347353aperi_tif
aprotic112715243apr_otic
argotic10310283_argotic
biotic103816613__biotic
critic103616813_cri_tic
deictic1237703de_ictic
deistic10311173de_istic
demotic12412353de_motic
despotic1346533despotic
ekistic1377843_ekistic
epidotic1346883epidotic
ergodic1145503_ergodic
eristics10610193_eristics
erotica92811513_er_otica
erotics91914153_er_otics
erratic9311123_erratic
exotic153112653_e_xotic
fermionic1643513fermionic
ferritic1347073ferritic
geriatric1244403geriatric
gerontic1147963gerontic
heretic12314833her_etic
heriot9422343heriot__
heriots10312063heriot_s
hermetic15310243hermetic
hermitic1539653hermitic
heroic113516923her_o_ic
herpetic1547773herpetic
heuristic1445983heuristic
idiotic1037463_idiotic
iritic83213823_iri_tic
juristic1746133juristic
kenotic1359713ke_notic
keratotic1545643keratotic
ketotic1348643ke_totic
leprotic1248583leprotic
leukotic1444523leukotic
lordotic1144993lordotic
meropic13310273mer_opic
miotic103715753__miotic
narcotic1277913narcotic
necrotic12310053necrotic
nepotic11310563ne_potic
neuritic1048593neuri_tic
neurotic1039703neurotic
noritic91213543nori_tic
operatic1249933oper_atic
papistic1448733papistic
parabiotic1645083parabiotic
paretic113016673par_etic
parodic122311723par_odic
parotid102915513par_otid
parsonic1239703parsonic
patristic1389293patristic
pearlitic1345523pearlitic
pectic122913873pe__ctic
pedantic1346583pedantic
pediatric1445273pediatric
peloric11310713pe_loric
pentomic1448143pentomic
peptic122113153pe__ptic
peptonic1448833peptonic
percoid12312323perco_id
peridia10312373peri_dia
peridot10514243peridot__
peridotite1354923peridotite
peridotitic1653033peridotitic
peridots1138323peridot_s
period9314983perio__d
periodical1546813periodical
periodids1345643periodids
periods10312243perio_ds
periostea1144793periostea
peripetia1346663peripetia
periphytic2264873periphytic
peripter1278753peripter
perisarc1245363perisarc
periscopic1854423periscopic
peritrich1645753peritrich
peritus9311803peri_tus
periwig1345163peri_wig
peroxid17310283per_oxid
petrolic1249693petrolic
phimotic1747153phimotic
photic133316443p__hotic
phreatic1548343phreatic
picritic1448263picri_tic
pietistic1346303pietistic
pionic103515953p__ionic
piratic11314293pir_atic
pleuritic1344553pleuri_tic
poditic122611583podi_tic
politic112918713poli_tic
practic13312253p_ractic
prelatic12311293prelatic
premeiotic1653133premeiotic
preriot9316413preriot__
priapic1346023p_riapic
probiotic1546663probiotic
pruritic1267403pruri_tic
psilotic1245773psilotic
psoriatic1387023psoriatic
ptotic102713373p__totic
pycnotic1745823pycnotic
pyelitic1547593pyeli_tic
pyknotic1944203pyknotic
pyretic143210783pyr_etic
pyridic15267833pyri_dic
pyrrolic1544563pyrrolic
rhotic112711233__rhotic
semeiotic1364653semeiotic
semiotics1376913semiotics
seriatim1049223seriatim
sermonic1248883sermonic
soritic91414433sori_tic
spermatic1548713spermatic
termitic1249283termitic
unerotic1049193uner_otic
veridic1338143veri_dic

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.423422437.4
2DLD Change Limit1461621488.07618098.3
3Display Results1481480.0632349.2
 (SQL Overall)1786911488.56220870.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.