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

126 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
asthmas1211736(None) 
asthma11126561asthma_
altheas1038232altheas
ashman1148382as_hman
asramas938302asramas
atmas75721012a_t_mas
isthmus1243262isthmus
stomas84816322_stomas
abohms1335003abohm_s
abomas101113583a_bomas
aethers103614943aethers
aftosas10147153aftosas
agamas97413453a_gamas
aghas97014873a_gh_as
agmas85919873a__gmas
almas76629773a__lmas
alohas9411703aloh_as
alphas1139513alph_as
althaeas1144213althaeas
althea938213althea_
amas67746293a___mas
anathemas1444883anathemas
animas84418723a_nimas
antas55432033ant__as
anthems12309423anthems
anthers103715203anthers
anthrax1757153anthrax
antiman9313883antiman
antimask1446573antimask
aromas81018613a_romas
arythmias1763863arythmias
asanas6514113as_anas
ashcan1135843as_hcan
ashcans1235183as_hcans
ashes86230613as_h_es
ashlar9338193as_hlar
ashlars10297063as_hlars
ashmen1168173as_hmen
ashram1139053as_hram
ashrams1236653as_hrams
ashtray13805553ashtray
ashtrays14534203ashtrays
asrama839193asrama_
assumes967163assumes
astasias8410143astasias
asterias8317013asterias
asters65631603ast_ers
asthenias1277453asthenias
astheny1345293astheny
asthmatic1647583asthmatic
asthmatics1745333asthmatics
astigmias1243463astigmias
astomous1047213astomous
astral66919283ast_ral
astrals75515243astrals
astray95615543ast_ray
astylar10265063astylar
ataman81013063a_taman
atamans9710433a_tamans
atlas55821583a_t_las
atma68121773a_t_ma_
atman75520143a_t_man
atmans84413963a_t_mans
atoms76817563a_tom_s
authors10311853authors
automan9310883automan
automat9414873automat
automats10410443automats
autumns943763autumns
bathmat14510143bathmat
bathmats1545933bathmats
blastemas1344693blastemas
blastomas1345523blastomas
brahmas1436733brahmas
diastemas12234393diastemas
earthman1346473earthman
gastreas957263gastreas
intimas9119583intimas
isthmi1143603isthm_i
isthmian1343073isthmian
isthmians1442553isthmians
isthmic1444793isthmic
kashas133311903kas_h_as
lithias1038823lithias
malthas1237913malth_as
mastabas1246803mastabas
masthead1435883masthead
mastheads1545243mastheads
osteomas1045333osteomas
pashas115117063pas_h_as
pastas85422873past__as
pastimes123611903pastimes
pastinas103712153pastinas
sataras7315063sataras
satsumas1043573satsumas
schemas1468163_schemas
schmos13379153_schmos
schwas14396983_schwas
shamas113717943_shamas
shams105829413_s_hams
sheas86331793_s_heas
shwas116415103_s_hwas
sigmas94111363_sigmas
simas75727553_s_imas
somas76030373_s_omas
stamps105614023_stamps
steams84916903_steams
stemmas11256973_stemmas
stems75219953_stem_s
stigmas10206643_stigmas
stimes85920573_stimes
stoas55126023_st_oas
stoma75918273_stoma_
stomal85213313_stomal
stomps105612833_stomps
strumas9419833_strumas
stumps104912283_stumps
stums75320083_stum_s
stupas83910883_stupas
summas104313163_summas
ultimas936363ultimas
xanthomas2143643xanthomas
yashmac1742563yas_hmac
yashmacs1842103yas_hmacs
yashmak1942743yas_hmak
yashmaks2042463yas_hmaks

Search took 9 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.470380193.6
2DLD Change Limit1340271267.50017870.3
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.01622291.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.