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

180 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
malarias1031377(None) 
malaria9313691malaria_
malarial10410611malarial
malarian10311561malarian
calvarias1447662calvarias
galabias1137732galabias
malaccas1445162malaccas
maladies11311932maladies
malangas1136862malangas
malarious1147042malarious
malarkies1545112malarkies
malaromas1345252malaromas
malars85020682malar__s
malvasias14154622malvasias
miliarias1148782miliarias
salariat8416302salariat
salariats947822salariats
salaries8319582salaries
talaria7412512talaria_
abasias9711013_abasias
acacias11510403_acacias
acarids105312243_acarids
adularias1044993adularias
agarics10319943_agarics
agrias74315393_a_grias
alanins7315803_alanins
alarms85913053_alar_ms
alarums9408923_alarums
alaskas1136683_alaskas
aldrins8310203_aldrins
alexias14249793_alexias
alias55834603_al__ias
ambaries123312383ambaries
ambaris113112163ambari_s
angarias9310553angarias
anurias7312253_anurias
aplasias10279233aplasias
aporias9315153_aporias
arias55438023___arias
ataxias14189343_ataxias
balatas9311833bala_tas
baldrics13164893baldrics
calcaria1249533calcaria_
caldaria1148953caldaria_
calorics122810463calorics
calories102919553calories
calvaria1347893calvaria_
calvarial1445693calvarial
calvarian1446863calvarian
calvaries1449803calvaries
canaries10318943canaries
claries93422203_claries
clarkias1444793_clarkias
dalasis8810533dalasi_s
dataries9314033dataries
filaria1039653filaria_
filariae1148473filariae
filarial1147863filarial
filarian1148313filarian
galabia1038323galabia_
galabiyas1542513galabiyas
galangas1046173galangas
galateas937143galateas
galaxies1637163galaxies
gallerias1047133gallerias
gazanias1845733gazanias
glorias81610323_glorias
halachas16317883halachas
halakhas18386723halakhas
halalas104214083hala_las
hamartias14115363hamartias
jalapins1745623jalapins
kalmias1347973kal_mias
lamias85020613__lamias
lariat6629043__lariat
lariats7615053__lariats
laris54737463__lari_s
larvas9310233__larvas
latakias1245583latakias
latrias71913213la_trias
maars74621633ma_ar__s
madeiras1144773madeiras
madras94316433ma_dr_as
madrasas11317763madrasas
maffias15327283ma_ffias
mafias113913573m__afias
maharajas2152783maharajas
mahatmas1543863mahatmas
mahonias1348063mahonias
majaguas1842843majaguas
makars124612633makar__s
malacca1344953malacca_
maladroits1353093maladroits
malaise9312673mala_ise
malaises10312333malaises
malanga1036663malanga_
malaprops1543253malaprops
malar76424443malar___
malarkey1743403malarkey
malarkeys1841963malarkeys
malarky1645433malar_ky
malaroma1245583malaroma
malates93522603mala_tes
malkins133311803mal_kins
mallards1138323mallar_ds
malthas1237913mal_thas
maltreat1048643maltreat
maltreats1145223maltreats
malvasia13164963malvasia_
malvasian14133873malvasian
mamaligas1443383mamaligas
manakins14209763manakins
mananas93414733mana_nas
mandarins12410393mandarins
mandrils1138493mandrils
manias84029033m__anias
manorial10311083manorial
mantras93815863mantr_as
manurial1047793manurial
maracas11313773mara_cas
marantas10310023marantas
maras75443293m__ar_as
marascas1247383marascas
margarins1248293margarins
margaritas1343853margaritas
maria75032883m__aria_
marinas93519393m__arinas
markas124717003m__arkas
marries93825283ma_rries
masalas9312053masa_las
mascaras1237693mascar_as
material10314103material
materials11510793materials
mazards1937703mazar_ds
mazurkas2372383mazurkas
melanian1048483melanian
melanics1237733melanics
melanins10310383melanins
melodias1148703melodias
miladies1139923miladies
miladis1049823miladi_s
miliaria1048783miliaria_
miliarial1147223miliarial
militias1048633militias
mojarras1742253mojarras
molarity13118903molarity
molars85517323molar__s
monardas1145713monardas
myalgias14123893myal_gias
mylars114310443mylar__s
palabras1267353palabras
paladins11911003paladins
palais8420423pala_i_s
palapas11311493pala_pas
palatial10410623palatial
pelorias10410593pelorias
planarias1147403planarias
ratafias1145323ratafias
safaris101110663safari_s
salamis9313513salami_s
salaried9311023salaried
salvias10279933sal_vias
samaras9312913samar_as
sangrias938373sangrias
sataras7315063satar_as
savarins1139893savarins
sharias102516003_sharias
solaria7312493solaria_
talars66021683talar__s
tamarins10310843tamarins
tamaris9413603tamari_s
tilapias1045293tilapias
uakaris1146633uakari_s
vagaries12310293vagaries
valerian1147123valerian
valerians1245343valerians
valonias1147473valonias
varias95019903__varias
velaria1038923velaria_
zamarras1943803zamarras

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 Limit1461621807.61019206.6
3Display Results1801800.0802250.0
 (SQL Overall)1786911808.11022033.4
 
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.