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

138 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
amanita931045(None) 
amanitas1048531amanitas
amanitin1048462amanitin
amenity1238332amenity
amentia9310152amentia
aminity12310512aminity
amnia75918642am_ni_a
amrita8411132am_rita
granita82111302granita
mania75634152_mani_a
manila84518302_manila
manito8518692_manito
manitu8315822_manitu
manta75629912_man_ta
abasia8712953abasi_a
acacia10311353acaci_a
acantha1254653acantha
acapnia1145913acapni_a
aconite9315473aconite
agita6315423__agita
alanin6317273alani_n
alanine7316863alanine
alanins7315803alanins
alant55742293alan_t_
alants67722023alan_ts
allanite8411093allanite
almandite1245093almandite
alunite7311633alunite
amain74922913ama_i_n
amandine1148553amandine
amanitins1147133amanitins
amarna839793ama_rna
amative12311733amative
amazing1938813amazing
amazonite2044213amazonite
ambit94223713am_bit_
ambits103713413am_bits
amboina1137963amboina
ament76036543amen_t_
amentias1039413amentias
aments85219803amen_ts
amia66836903am__i_a
amiga85514813am__iga
aminic104413513amini_c
amity10416093am__ity
ammonia1148693ammoni_a
ammonite1249143ammonite
amnic95516243am_ni_c
amnio75218053am_ni_o
amnion84812053am_nion
amnios84912523am_nios
amniote936963am_niote
amosite9313163amosite
amreeta945163amreeta
amritas939093am_ritas
amusia839173amusi_a
anality10313633anality
anima74620073__anima
anta46839583__an_ta
apatite9312963apatite
aphanite1348773aphanite
apimania1245473apimani_a
arabica1147283arabica
arenite71017713arenite
armonica1276863armonica
arnica8310443a_rnica
asana5315483asan__a
ataxia13179593ataxi_a
atonia63816513atoni_a
avant86224663avan_t_
await85524493awa_it_
awaits96411953awa_its
bonita8312943_bonita
capita102913773_capita
casita82913703_casita
crania82418433crani_a
cyanite122710763cyanite
emanate9312473emanate
emerita938713emerita
fajita1635923_fajita
gazania1746123gazani_a
granitas92610223granitas
granite82017083granite
hamartia13115943hamartia
haniwa1236743_haniwa
humanity1646313humanity
inanity1039503inanity
kamaaina1443273kamaaina
kamacite1645293kamacite
kyanite14237313kyanite
lanital7310913_lanital
mafia104418033_mafi_a
makuta1236393_makuta
mamaliga1344133mamaliga
mana65341963_man__a
manana84816073_manana
manat76039993_manat_
manats84623463_manats
manga85026203_man_ga
maniac103917973_maniac
manias84029033_manias
manic94629443_mani_c
manics103919933_manics
manilas93915873_manilas
manilla93012473_manilla
manioc103914823_manioc
manioca11358943_manioca
manitos9314053_manitos
manitou938463_manitou
manitus9310923_manitus
manna75522543_man_na
mannite9312903mannite
mantas85725363_man_tas
mantic104120903_mantic
mantid93820383_mantid
mantis83926033_mantis
mantra84116093_mantra
mantua84412023_mantua
manzanita2043013manzanita
maranta9311693maran_ta
maria75032883_mari_a
marina84623413_marina
marital92314183_marital
maxima17568633_maxima
menta74424423_men_ta
minima105512653_minima
omenta83411723omen_ta
quanta153911333quan_ta
raita54623073_ra_ita
ramenta9311183ramen_ta
samaritan1144183samaritan
sancta839833_sancta
sanity9316203_sanity
tamandua1142593tamandua
umangite1144823umangite
urania62516123urani_a
uranite72515693uranite
vanity12311933_vanity

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340271386.11021935.7
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.57627173.2
 
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.