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

106 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
marlitic123834(None) 
aplitic11311742_aplitic
carditic1348702carditic
mannitic1248012mannitic
marlite92917072marlit_e
marlites103415262marlites
mastitic1248262mastitic
pearlitic1345522pearlitic
perlitic12310582perlitic
uralitic10158452uralitic
aclinic11188973_aclinic
aerolitic1149343aerolitic
albitic1139133_albitic
anaclitic1346503anaclitic
arctic10313513_ar_ctic
argotic10310283_argotic
artistic10310893_artistic
ascitic1139323_ascitic
augitic1038283_augitic
balletic1248073balletic
ballistic1346613ballistic
barytic1437823bar_ytic
bauxitic1943623bauxitic
bornitic1246473bornitic
calcitic1148193calcitic
carditis11310223carditis
caryatic1548493caryatic
clitic103315053__clitic
colitic112916193_colitic
critic103616813_cr_itic
enclitic1247513enclitic
ferritic1347073ferritic
garlic9310043garl__ic
granitic1168623granitic
hermitic1539653hermitic
hoplitic1558183hoplitic
illitic939253_illitic
impolitic1546583impolitic
iritic83213823_ir_itic
jaditic1746703ja_ditic
kaolinic1444703kaolinic
karstic1357983kar_stic
magmatic1548393magmatic
magnetic1349233magnetic
magnific1654213magnific
mahlstick2052193mahlstick
maieutic1243873maieutic
majestic1944913majestic
malefic1486323ma_lefic
malic94525663ma_l__ic
maloti8313213ma_loti_
mammitis1145593mammitis
mantic104120903ma__ntic
marasmic1446163marasmic
margaric1346063margaric
marital92314183mar_ital
maritime1247383mar_itime
marlier92614773marli_er
marliest102415183marliest
marlin84220903marl__in
marline93320953marli_ne
marlines103818713marlines
marling103322763marli_ng
marlings113713493marlings
marlins93420473marli_ns
marmite112413993marmit_e
marmites122212793marmites
martin84122523mar__tin
martini93613873martini_
martinis103311613martinis
mastic103119173ma__stic
mastitis1039103mastitis
maulstick1742723maulstick
mellific1544643mellific
mephitic1747143mephitic
meristic12311253meristic
militia949733m_ilitia
mirliton1044183mirliton
morainic12125673morainic
moralistic1446803moralistic
morbific1743183morbific
myelinic1544243myelinic
myelitis1345113myelitis
narcistic1346443narcistic
narcotic1277913narcotic
neritic91314333ner_itic
noritic91213543nor_itic
oolitic92512883_oolitic
paralytic1647973paralytic
parasitic1349523parasitic
paretic113016673par_etic
parotic112518043par_otic
parotitic1349333parotitic
pelitic111814653_pelitic
politic112918713_politic
poplitic14510013poplitic
pyelitic1547593pyelitic
pyritic143311313pyr_itic
rachitic1547593rachitic
soritic91414433sor_itic
stylitic1356343stylitic
tallitim1065503tallitim
taxitic1637093ta_xitic
termitic1249283termitic
uranitic10148683uranitic
zeolitic1947463zeolitic

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.420425454.8
2DLD Change Limit1461621067.72018932.9
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.18621828.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.