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

104 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
malarian1031156(None) 
malaria9313701malaria_
malarial10410611malarial
malarias10313771malarias
calvarian1446862calvarian
filarian1148312filarian
malvasian14133872malvasian
melanian1048482melanian
salariat8416302salariat
talaria7412522talaria_
valerian1147122valerian
acaridan1165233_acaridan
agrarian948253agrarian
alanin6317273_alani_n
alation72920553_alation
aldrin7311243_aldri_n
apiarian1048323apiarian
aquarian1747013aquarian
barbarian1346343barbarian
caesarian1147053caesarian
calcaria1249543calcaria_
caldaria1148953caldaria_
calvaria1347893calvaria_
calvarial1445693calvarial
calvarias1447663calvarias
cesarian1048183cesarian
clarion9311663_clarion
dalmatian1244643dalmatian
filaria1039653filaria_
filariae1148473filariae
filarial1147863filarial
galabia1038333galabia_
galabias1137733galabias
halation11313853halation
jalapin1645923jalapi_n
kalian10312163kal__ian
lariat6629043__lariat
lunarian847293lunarian
macaroon1246343macaroon
magian9312833m__agian
magician1346133magician
maharani1344623mahar_ani
malacca1344963malacca_
malaccas1445163malaccas
maladies11311933maladies
malaise9312673mala_ise
malanga1036663malanga_
malangas1136863malangas
malapropian1762073malapropian
malar76424443malar___
malarious1147043malarious
malarkey1743413malarkey
malarkies1545123malarkies
malarky1645433malar_ky
malaroma1245593malaroma
malaromas1345253malaromas
malars85020683malar__s
malathion1444513malathion
malign939853mal__ign
malkin122913153mal_ki_n
maltreat1048653maltreat
malvasia13164963malvasia_
malvasias14154623malvasias
mammalian1243723mammalian
manakin131810643manaki_n
mandarin11411023mandari_n
manorial10311083manorial
manurial1047793manurial
margarin1148073margari_n
maria75032883m__aria_
marina84623413m__arina
martian93514683ma_rtian
material10314103material
melanin9310893melani_n
milesian1046473milesian
miliaria1048783miliaria_
miliarial1147223miliarial
miliarias1148783miliarias
molarity13118903molarity
ovarian1037643_ovarian
pagurian1144613pagurian
paladin101011773paladi_n
palatial10410623palatial
papyrian1544563papyrian
parian83223963__parian
pelorian1048883pelorian
planarian1147113planarian
riparian1047523riparian
rosarian847593rosarian
salariats947823salariats
salaried9311033salaried
salaries8319593salaries
salaryman1462653salaryman
salpian938493sal_pian
salvarsan1242263salvarsan
samaritan1144183samaritan
saurian739913sa_urian
savarin10310003savari_n
silurian846293silurian
solaria7312493solaria_
tamarin9311923tamari_n
valerians1245343valerians
velaria1038923velaria_
vulgarian1354263vulgarian

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 Limit1461621048.39017421.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911048.84320207.1
 
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.