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

263 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
armada93878(None) 
armadas1038171armadas
ramada9310181ramada
aggada955222aggada
arcade91013642arcade
arcadia1039702arcadia
arcana8912582arcana
argala74712672argala
armed86324432armed_
hamada1239922hamada
hammada1545092hammada
ramadas1039302ramadas
abaca95118043a_baca
abaka114313823a_baka
abaya104413173a_baya
abomasa11114613abomasa
abrade9313053abrade
abroad9310943abroad_
adman84517903adma_n
admass957143admass
agama85815583a_gama
agenda837253agenda
aggadah1362863aggadah
aggadas1055003aggadas
agma77623263agm__a
agmas85919873agma_s
ahead96817053ahead_
aimed85626053aimed_
airmail946213airmail
airman82414223airma_n
alameda1035493alameda
albata839333albata
alcade91111513alcade
alma66333023alm__a
almah106917253alma_h
almahs118611613almahs
almanac1156033almanac
almas76629773alma_s
almud84012183almud_
almude9399933almude
almuds9378773almuds
alpaca1047383alpaca
already1144263already
ama510853303a_m__a
amadou977613a_madou
amah98927493a_ma_h
amahs107819063a_mahs
amain74922913a_main
amarna839793a_marna
amas67746293a_ma_s
amass77119683a_mass
amaze166016603a_maze
ameba9312383a_meba
amia66836903a_m_ia
amid77036353a_mid_
amide86128483a_mide
amido85720983a_mido
amids85627513a_mids
amiga85514813a_miga
amnia75918643a_mnia
amrita8411133amrita
arak86929573ar_a_k
araks94820883ar_aks
arame75026623ar_ame
arames84622573arames
aramid93315613aramid
aramids102810513aramids
arcaded1178973arcaded
arcades101113193arcades
arcadian1147763arcadian
arcadias1149163arcadias
arcane81216743arcane
arced88224163arced_
archaea12137613archaea
area45843393ar__ea
areae55229743area_e
areal55928733area_l
areas55935773area_s
areaway1335913areaway
areca75618633ar_eca
arena55323813ar_ena
areola6813673areola
arepa75615563ar_epa
argal65023393arga_l
argalas84011093argalas
argali75013753argali
argals75517713argals
arhat8327093arha_t
arhats9312973arhats
aria46245423ar__ia
ariary94114203ariary
arias55438023aria_s
arid57642713ar_id_
arista6415293arista
arm58449623arm___
armagnac1342893armagnac
armband1265983armband
armbands1355143armbands
armer76924443arm_er
armers85520273armers
armet76739453arm_et
armets84918353armets
armful1167163armful
armies85123693armies
armilla936993armilla
arming94719803arming
armlet84118193armlet
armload1044293armload
armloads1144233armloads
armor75118053arm_or
armors85017813armors
armory114211473armory
armour84411853armour
armpit10811093armpit
arms66137493arm__s
armure8710133armure
army96624183arm__y
arnica8310443arnica
aroid65428343aroid_
aroids75118223aroids
aroma71220143ar_oma
aromas81018613aroma_s
arrack121110253arrack
arrant6623253arrant
arras55626133arra_s
array86317143arra_y
arrayal1055843arrayal
arrays95311683arrays
arriba867683arriba
arroba898663arroba
artal55525473arta_l
arval86017013arva_l
asana5315483a_sana
asrama839193asrama
atma68121773atm__a
atman75520143atma_n
atmans84413963atmans
atmas75721013atma_s
aubade939223aubade
audad71511393audad_
audads8167103audads
axman144813183axma_n
barmaid1238203barmaid
barmaids1345943barmaids
barman103519703barma_n
bemadam1445773bemadam
bemata10411693bemata
brad75234343br_ad_
brads85528293br_ads
brava106414793br_ava
braza165214253br_aza
bread85523113bread_
breads95419203breads
bready124511183bready
broad84817693broad_
broadax1744453broadax
broads94515153broads
caramba1336893caramba
carman103920743carma_n
cicada1136413cicada
comade114415323comade
dada66422443__dada
drama85117413dr_ama
dramady1443553dramady
dread74419023dread_
dreads84115023dreads
dryad10477583dryad_
dryads11436623dryads
earmark1345653earmark
errata639013errata
farad95720673far_ad_
faraday1445633far_aday
farads104713273far_ads
farmed125117653farmed_
fermata12278143fermata
gammadia1443923gammadia
garda7316763gar__da
gelada837623gelada
grad66829863gr_ad_
grade75126093gr_ade
grads75625753gr_ads
grama85620283gr_ama
gramma11499803gramma
grampa115010173grampa
grana65722093gr_ana
haggada1353643haggada
hamadas1339673hamadas
hammadas1644793hammadas
hariana10310243hariana
harmed125218833harmed_
irade65618153ir_ade
jemadar1743373jemadar
kamala12339963kamala
karma113415003karm__a
karmas123013733karma_s
lambada1245643lambada
lambda1146113lambda
mad68958713__mad_
madam10316223__madam
made75440243__made
mads76845373__mads
magmata1237463magmata
mama86231593__mama
mana65341963__mana
manmade1237963manmade
mara67444573__mara
maraca10314153mar_aca
marsala939583marsala
masa65034723__masa
maya95824593__maya
nada58022903__nada
nomad86016183nomad_
nomads94711603nomads
omasa749483_omasa
orad56031693or_ad_
oread64619603oread_
oreads73915773oreads
organa789213organa
panada94113053panada
parade94720643par_ade
parkade1437583parkade
pomade113611333pomade
posada937163posada
premade12311443premade
rad47662003_r_ad_
radar61316723_r_adar
rads56046603_r_ads
raga55930813_r_aga
raia46638383_r_aia
raja117918683_r_aja
ramal74622243rama_l
ramate83921683ramate
rambla103510933rambla
ramona8412413ramona
raya75224823_r_aya
read55942533_read_
readd74617133_readd
reads64835273_reads
ready94821503_ready
reata54225393_reata
remade94316983remade
remuda936823remuda
riata54618023_riata
road56332113_road_
roads66523623_roads
ruana5312423_ruana
samara8313853samara
sardana838643sardana
somata8312383somata
sradha1085333sr_adha
tarama8412733tar_ama
tarmac10310333tarma_c
tarmacs1138323tarmacs
tartana73010193tartana
trad55630913tr_ad_
trade65026043tr_ade
tread64821703tread_
treads74817923treads
triad65217723triad_
triads74513533triads
trymata1244223trymata
unmade92911063unmade
warmed124516893warmed_

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162635.32621163.3
3Display Results2632630.0803287.5
 (SQL Overall)1786912635.78230904.7
 
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.