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

146 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
asthma1112656(None) 
asthmas12117361asthmas
althea938192althea
ashman1148382as_hman
asrama839192asrama
atma68121772a_t_ma
isthmi1143602isthmi
stoma75918272_stoma
abohm1247973abohm_
abohms1335003abohms
aboma91114603a_boma
acta69524803act__a
aether94213673aether
aftosa996573aftosa
agama85815573a_gama
agha87417303a_gh_a
agma77623263a__gma
aha611246643a__h_a
alma66333023a__lma
aloha8513613aloh_a
alpha1049653alph_a
althaea1044353althaea
altheas1038223altheas
altho86312603alth_o
ama510853303a___ma
anathema1344583anathema
anima74620073a_nima
anta46839583ant__a
anthem113410343anthem
anthemia1349193anthemia
anthems12309423anthems
anther93715063anther
anthrax1757153anthrax
antiman9313883antiman
antra56521923ant_ra
aphtha1444483aphtha
aroma71220143a_roma
arythmia1643953arythmia
asana5315483as_ana
asea46327183as__ea
ash67944603as_h__
ashcan1135843as_hcan
ashed97829773as_hed
ashen87818673as_hen
ashes86230613as_hes
ashlar9338193as_hlar
ashmen1168173as_hmen
ashram1139053as_hram
ashtray13805553ashtray
ashy107717353as_h_y
asramas938303asramas
assume897563assume
astasia7310933astasia
aster55434893ast_er
asteria7316173asteria
astern64815813astern
asters65631603asters
asthenia1167713asthenia
astheny1345293astheny
asthmatic1647583asthmatic
astigmia1143363astigmia
astir55517093ast_ir
astony9510523astony
astral66919283astral
astray95615543astray
astute6310763astute
astylar10265063astylar
asyla839333as_yla
ataman81013063a_taman
atman75520143a_t_man
atmas75721013a_t_mas
atom67824523a_tom_
atoms76817563a_toms
atomy107415193a_tomy
atria56022333a_tria
author939763author
automan9310883automan
automat9414873automat
autumn836013autumn
bathmat14510143bathmat
blastema1244683blastema
blastoma1245443blastoma
brahma1336193brahma
diastema11264743diastema
earthman1346473earthman
ecthyma1752603ecthyma
etyma1036583_etyma
gastrea847223gastrea
intima81910023intima
ischia1136393ischia
isthmian1343073isthmian
isthmic1444793isthmic
isthmus1243253isthmus
kasha124710723kas_h_a
lithia939333lithia
maltha1137503malth_a
mastaba1146223mastaba
masthead1435883masthead
optima10106533optima
osteoma945423osteoma
ostia52315583ost_ia
ostomy1137823ostomy
pasha105417183pas_h_a
pasta76624533past__a
pastime114611973pastime
pastina93914593pastina
satara6315533satara
satem76021453satem_
satsuma943873satsuma
schema1388373_schema
schmo124510203_schmo
schwa13426843_schwa
sha69837783_s_h_a
sham96436353_s_ham
shea76031573_s_hea
shmo95318093_s_hmo
shwa106014963_s_hwa
sigma84513823_sigma
sima64730783_s_ima
soma65635293_s_oma
stamp95217363_stamp
steam76322923_steam
stela54019043_stela
stem610628243_stem_
stemma10328133_stemma
stems75219953_stems
stigma9226753_stigma
stime76521793_stime
stimy105114733_stimy
stoa45425913_st_oa
stomal85213313_stomal
stomas84816323_stomas
stomp95616663_stomp
stria55723203_stria
stroma84313073_stroma
struma84313273_struma
stum65526013_stum_
stump94616463_stump
stums75320083_stums
stupa74112313_stupa
stymy13358293_stymy
summa94713313_summa
ultima836313ultima
xanthoma2043973xanthoma
yashmac1742563yas_hmac
yashmak1942743yas_hmak

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161466.48317386.4
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.