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

242 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
asrama83919(None) 
asramas938301asramas
agama85815582a_gama
arame75026622a_rame
aroma71220142a_roma
asana5315482as_ana
ashram1139052ashram_
ashrams1236652ashrams
asthma11126562asthma
drama85117422_drama
grama85620282_grama
tarama8412732tarama
abaca95118043a_baca
abaka114313823a_baka
abamp11310603a_bamp
abaya104413173a_baya
abeam9316533abeam_
aboma91114603a_boma
abrade9313053abrade
acrasia9310033acrasia
acromia1139963acromia
aerate64830553aerate
aflame1138723aflame
afraid1049723afraid
agamas97413453a_gamas
aggada955223aggada
agma77623263a__gma
agrafe1038093agrafe
agrapha1345133agrapha
agria65517143agr_ia
airman82414223airman
alamo7418143a_lamo
alarm76621423alarm_
alarms85913053alarms
albata839333albata
alma66333023a__lma
alpaca1047383alpaca
ama510853303___ama
amarna839793amarna
amrita8411133amrita
anima74620073a_nima
aorta55922573aor_ta
apraxia1646893apraxia
arak86929573a_ra_k
araks94820883a_raks
arames84622573a_rames
aramid93315613a_ramid
arcana8912583arcana
area45843393a_r_ea
areca75618633a_reca
arena55323813a_rena
arepa75615563a_repa
argala74712673argala
aria46245423a_r_ia
arm58449623a_r_m_
armada938783armada
arms66137493a_r_ms
army96624183a_r_my
aromas81018613a_romas
arrack121110253arrack
arrant6623253arrant
arras55626133arra_s
array86317143arra_y
arrayal1055843arrayal
arrays95311683arrays
arriba867683arriba
arroba898663arroba
arum66129033a_rum_
arums75517833a_rums
asanas6514113as_anas
asarum84610913asarum
asarums9467613asarums
asea46327183as__ea
ashamed1336243ashamed
ashman1148383ashman
askant10412713askant
aslant6317753aslant
aspirata1054993aspirata
assagai843903assagai
assai5711543assa_i
assail6610153assail
assais6711963assais
assay8710283assa_y
assays977903assays
assume897563assume
astasia7310933astasia
asthmas12117363asthmas
astragal945623astragal
astral66919283astra_l
astrals75515243astrals
astray95615543astra_y
aswarm11107913aswarm
asyla839333as_yla
ataman81013063a_taman
atma68121773a__tma
atria56022343atr_ia
aura45836253aur__a
aurae54128113aura_e
aural54428963aura_l
aurar54420253aura_r
auras55932563aura_s
aurate64426473aurate
aurora6411763aurora
aurum7614963aurum_
aurums849383aurums
brahma1336193_brahma
brava106414793_brava
braza165214253_braza
caramba1336893caramba
casaba1079263cas_aba
casava1157873cas_ava
cascara1138313cascara
cassaba1145663cassaba
cassata938143cassata
cassava1255003cassava
ceramal1138843ceramal
chroma132912473chroma
cram85635493_cram_
cramp115120693_cramp
crams96229153_crams
curara83712203curara
derma84918513der_ma
dharma1276103dharma
diorama1046533diorama
diram84419473diram_
dirams94413703dirams
dram75832003_dram_
dramas95814663_dramas
drams86025833_drams
errata639013errata
foram105124933foram_
forams115115913forams
frame105821803_frame
gama77035523__gama
gastraea954403gastraea
gram77034583_gram_
gramas94317203_gramas
gramma11499803_gramma
gramp106218323_gramp
grampa115010173_grampa
grams85327313_grams
grana65722093_grana
herma105318883her_ma
ihram10310183ihram_
ihrams1137173ihrams
jicama1734883jicama
joram145816983joram_
jorams154810533jorams
karma113415003kar_ma
korma115913073kor_ma
lama66635293__lama
llama799893_llama
macrame1338713macrame
madrasa10387883madrasa
mama86231593__mama
maraca10314153maraca
marram10313883marram_
marrams11310123marrams
marsala939583marsala
masala8311813mas_ala
mascara1138023mascara
mastaba1146223mastaba
ostraca937823ostraca
ostraka1144833ostraka
pajama17317653pajama
panama104213353panama
panorama1244943panorama
paramo102614643paramo
pastrami1246333pastrami
pirana8713263pirana
piraya1167713piraya
praam94815613_praam
pram85733493_pram_
prams96125513_prams
prima95019343_prima
purana8712933purana
pyjama20303483pyjama
raga55930813__raga
raia46638383__raia
raja117918683__raja
ram56867273__ram_
ramal74622243__ramal
rami66034093__rami
ramp85934003__ramp
rams65950773__rams
raya75224823__raya
saga55331173_s_aga
sagaman10117563sagaman
salaam8711013salaam
salami8313103salami
samara8313853samara
samba95618773_s_amba
same65245643_s_ame
samp85733593_s_amp
saran53730303sara_n
sarans64224433sarans
sarape84817573sarape
sarcoma1147403sarcoma
sardana838643sardana
satara6315533satara
scam85932353_scam_
scamp115717313_scamp
scams94423973_scams
scram910621623scram_
scrams105216623scrams
seam66645973_seam_
seaman84015903_seaman
seams75731663_seams
seamy105921273_seamy
sham96436363_sham_
shaman113314283_shaman
shamas113717943_shamas
shame105726703_shame
shams105829413_shams
sigma84513833_sigma
sima64730783_s_ima
slam67737973_slam_
slams74927903_slams
soma65635293_s_oma
spam85930043_spam_
spams94922193_spams
squama1736533squama
sradha1085333_sradha
stamp95217363_stamp
stoma75918273_stoma
strata63616283strata
stroma84313073stroma
struma84313273struma
summa94713313_summa
swam96329983_swam_
swami105614523_swami
swamp125015323_swamp
swamy136714403_swamy
taramas9612703taramas
tram67034553_tram_
tramp96319773_tramp
trams75327673_trams
trauma838803_trauma
tryma1037223_tryma
ulama7711473_ulama
ziram163912893ziram_
zirams17438643zirams

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.406440125.6
2DLD Change Limit1127162425.01322484.7
3Display Results2422420.0803025.0
 (SQL Overall)1786912425.49932495.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.