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

121 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
perlitic1231058(None) 
pearlitic1345521pearlitic
pelitic111814651pe_litic
aerolitic1149342aerolitic
ferritic1347072ferritic
hermitic1539652hermitic
marlitic1238342marlitic
neritic91314332ner_itic
periotic12313442periotic
periti8319952per_iti_
perlite9317322perlit_e
perlites10316362perlites
politic112918712p_olitic
poplitic14510012poplitic
prelatic12311282prelatic
pyelitic1547592pyelitic
pyritic143311312pyr_itic
termitic1249282termitic
zeolitic1947462zeolitic
aperitif1347343aper_itif
aplitic11311743_aplitic
bornitic1246473bornitic
carditic1348703carditic
cerotic11415063cer_otic
clitic103315053__clitic
colitic112916193_colitic
critic103616813_cr_itic
deltic9312503de_l_tic
ecliptic1455333_ecliptic
elliptic1254753_elliptic
enclitic1247513enclitic
eolithic1375853_eolithic
eremitic1248543_eremitic
ergotic1049723_ergotic
eristic9814093_eristic
erotic82620273_er_otic
erratic9311113_erratic
felsitic1345033felsitic
ferritin1147383ferritin
gerontic1147963gerontic
heretic12314833her_etic
hermetic15310243hermetic
herpetic1547773herpetic
hoplitic1558183hoplitic
illitic939253_illitic
iritic83213823_ir_itic
jesuitic1743383jesuitic
leucitic1245233leucitic
mellific1544643mellific
mephitic1747143mephitic
meristic12311253meristic
neolithic1483933neolithic
neuritic1048593neuritic
noritic91213543nor_itic
oolitic92512883_oolitic
operatic1249933oper_atic
paralytic1647973paralytic
parasitic1349523parasitic
paretic113016673par_etic
parotic112518043par_otic
parotitic1349333parotitic
pearlite1039443pearlit_e
pearlites1138233pearlites
pectic122913873pe__ctic
pedantic1346583pedantic
pelagic1237863pe_lagic
pelite84323003pe_lit_e
pelites93821993pe_lites
peloric11310713pe_loric
pelvic13307553pe_l_vic
penlite9313243penlit_e
penlites10312273penlites
peptic122113153pe__ptic
peptidic1544553peptidic
perdition1249013perdition
peridia10312363per_idia
peridotic1446483peridotic
periodic1348433periodic
peritrich1645753per_itrich
peritus9311803per_itus
periwig1345163per_iwig
permit10321683permit__
permits11314003permit_s
peroxidic2144473peroxidic
phreatic1548343phreatic
phyletic1847213phyletic
phyllitic1944423phyllitic
picritic1448263picritic
piratic11314293pir_atic
pisolitic1347103pisolitic
pleuritic1344553pleuritic
poditic122611583p_oditic
politick16289333p_olitick
politico122510013p_olitico
politics122513813p_olitics
pollinic1247333pollinic
practic13312243p_ractic
prebiotic1545413prebiotic
prelimit1259123prelimit
proclitic1548113proclitic
prolific1546743prolific
pruritic1267403pruritic
psephitic1844183psephitic
psilotic1245773psilotic
punditic1364983punditic
puristic1239383puristic
pyelitis1346583pyelitis
pyretic143210783pyr_etic
pyridic15267833pyr_idic
pyrolytic1957053pyrolytic
realistic1148553realistic
soritic91414433sor_itic
spermatic1548713spermatic
spherulitic1871543spherulitic
stylitic1356343stylitic
tektitic1444133tektitic
terrific1344803terrific
uralitic10158453uralitic
veridic1338143ver_idic
veristic1339883veristic
xerotic16410863xer_otic

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621216.57622226.6
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.05825317.5
 
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.