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

243 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
amritas93909(None) 
amrita8411131amrita_
afrits9311902afrit_s
agitas7310592a_gitas
agrias74315392agri_as
amanitas1048532amanitas
ambits103713412ambit_s
amias75831472am_i_as
amigas95912172am_igas
amreetas1044272amreetas
aortas65417782aor_tas
arias55438022a_ri_as
aristas7413522a_ristas
caritas93316962caritas
emeritas1046432emeritas
marinas93519392marinas
marital92314182marital
veritas103012752veritas
abris75722603abri__s
adits66523713a_dit_s
admits9411413admit_s
aerates74627493aerates
aerial64625713aeri_al
aerials74017553aerials
aeries64737783aeri_es
afrit8323173afrit__
agita6315423a_gita_
agria65517143agri_a_
airings83913843airings
airths95414253air_ths
airts55626343air_t_s
aits46355533a__it_s
ajivas1655133a_jivas
albatas938373albatas
albites9313203albites
alias55834603a_li_as
aliyas93911803a_liyas
amanita9310453amanita_
amas67746293am___as
amberinas1344613amberinas
ambit94223713ambit__
amboinas1246033amboinas
ambries111614553ambri_es
amebas10311453am_ebas
amentias1039413amentias
aments85219803ament_s
amia66836903am_i_a_
amices105018013am_ices
amicus103810003am_icus
amidase1036733am_idase
amides95722663am_ides
amids85627513am_i_ds
amies76837693am_i_es
amiga85514813am_iga_
amigos94511213am_igos
amines84727983am_ines
amins75534323am_i_ns
amirate91115953amirate
amirates101114793amirates
amirs75924923am_i_rs
amis66445323am_i__s
amiss75823073am_i_ss
amities9317383am_ities
amity10416093am_it_y
ammines11312673ammines
amnia75918643amni_a_
amnions93710913amnions
amnios84912523amni_os
amniotes1036603amniotes
amoebas1135963amoebas
amorists10411333amorists
amosites10311233amosites
amreeta945163amreeta_
amusias938583amusias
anginas8310953anginas
animas84418723a_nimas
antas55432033a__ntas
antitax1447853antitax
anurias7312253anuri_as
aorists74215833aorists
aorta55922573aor_ta_
aortae65115473aor_tae
aortal65217513aor_tal
aplites9314933aplites
aporias9315153apori_as
areas55935773a_r_eas
arecas84817443a_recas
arenas65021993a_renas
arepas85515703a_repas
aretes64425353a_retes
arhats9312973a_rhats
aria46245423a_ri_a_
ariels65119373a_riels
ariettas847393a_riettas
arils58732203a_ri_ls
arises65233803a_rises
arista6415293a_rista_
aristae7312533a_ristae
aristos7312373a_ristos
armadas1038173armadas
armets84918353armet_s
armies85123693armi_es
armillas1046663armillas
armings103811503armings
armpits1157133armpit_s
arnicas939543arnicas
aromas81018613a_romas
arras55626133a_r_ras
arriba867683arriba_
arris56824683arri__s
arrises71617583arrises
arrival1037563arrival
arrivals1145943arrivals
arrives101311513arrives
arrobas969213arrobas
artal55525473a_r_tal
arts49650263a_r_t_s
ascites9312603ascites
asramas938303asramas
atria56022343atri_a_
atrial65418943atri_al
atriums939043atriums
attrites8311563attrites
attrits7310613attrit_s
aubrietas1142833aubrietas
audits72814113audit_s
augites8312183augites
auras55932563aur__as
auris55331533auri__s
aurists74615783aurists
auroras7311703auroras
awaits96411953await_s
axites134913833a_xites
azurites1737283azurites
baristas1039723baristas
barites94322333barites
barytas12378283barytas
bonitas939453bonitas
briths115113863_briths
brits76433083_brit_s
britts84813443_britts
camisas113411923cam_isas
carinas93622413carinas
casitas93312043casitas
cerias83321983ceri_as
cerites94823433cerites
crits75527573_crit_s
curites93919863curites
ditas65923673__ditas
emerita938713emerita_
emeritae1046353emeritae
emeritus1045173emeritus
emits75421473em_it_s
ericas8315463_ericas
erratas736863erratas
fajitas1734253fajitas
farinas103215243farinas
ferias95020393feri_as
frites94922483_frites
friths124313583_friths
frits86129103_frit_s
fritts94613193_fritts
gambias125010733gambi_as
gambits12399723gambit_s
gorditas1043923gorditas
griths105211653_griths
grits65529583_grit_s
hamartias14115363hamartias
iritis63113733_iritis
jarinas143712193jarinas
kurtas10349883kur_tas
lamias85020613lam_i_as
laminas93615873lam_inas
lariats7615053lariats
latrias71913213latri_as
litas54923773__litas
mafias113913573mafi_as
mammitis1145593mammitis
manias84029033mani_as
manilas93915873manilas
manitos9314053manitos
manitus9310923manitus
mantas85725363_mantas
maracas11313773maracas
marantas10310023marantas
maras75443293mar__as
maria75032883mari_a_
marimbas1444363marimbas
marina84623413marina_
marines93928013marines
markas124717003mar_kas
markkas12356083markkas
marlites103415263marlites
marmites122212793marmites
martial92415413martial
martian93514683martian
martians103111613martians
martins93322063martins
marts77442233mar_t_s
mbiras1077153_mbiras
merits8320873merit_s
micas96823053_m_icas
minas75434113_m_inas
mirths114912993_mirths
mirzas1738183_mirzas
mites75141803_m_ites
mitis75425993_m_itis
mitts75523753_m_itts
myricas1436753myricas
norias65518203nori_as
norites74018803norites
omits75018263om_it_s
papricas1447053papricas
paprikas1643853paprikas
partitas10310253partitas
peritus9311803peritus
pitas77427673__pitas
primas104418103_primas
puritan939283puritan
puritans1037633puritans
pyrites12812203pyrites
raitas64417673_raitas
rias45540593__ri_as
riatas63915093__riatas
rites54442553__rites
rotas54827723__rotas
samaritan1144183samaritan
samaritans1242933samaritans
samites93118713sam_ites
smites83921923sm_ites
smiths114711023sm_iths
sorites73825243sorites
sprites94220333sprites
sprits85122533sprit_s
stratas73013583stratas
tortas64918253tor_tas
turistas846693turistas
varias95019903vari_as
verites103822263verites
writes94420333_writes
writs86624383_writ_s
zamias174212923zam_i_as
zaribas1836043zaribas

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 Filter1786911340270.390458182.1
2DLD Change Limit1340272436.78319759.3
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.26624592.8
 
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.