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

178 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
asarum8461091(None) 
alarum85411981alarum
asarums9467611asarums
acarus8312192acarus
alarm76621422alar_m
alarums9408922alarums
antrum8611312antrum
arum66129032__arum
ashram1139052ashram
aswarm11107912aswar_m
asylum1144892asylum
aurum7614962a_urum
estrum81810512estrum
labarum1166012labarum
larum74317972_larum
sacrum103910142sacrum
sagum8512872_sagum
scrum95418202_scrum
serum75223472_serum
strum75619452_strum
aargh96314083a_argh
abacus10349763abacus
acari75020283acar_i
acarid95017073acarid
accrue1035823accrue
acetum1038463acetum
adytum1243733adytum
aecium10410423aecium
afar76720783afar__
afars85716513afar_s
agar58726413agar__
agaric93513633agaric
agars66120643agar_s
ajar116217703ajar__
alar46340073alar__
alarms85913053alarms
alarumed1143313alarumed
alary86123443alar_y
album92312653a_lbum
algum82711763a_lgum
allium8311243allium
alum65227613__alum
amarna839793amarna
amylum1344693amylum
anadem939183anadem
anagram1058193anagram
anarch11310393anarch
antrums969173antrums
apart74330673apar_t
aquarium1945383aquarium
arcanum1176443arcanum
arm58449623__ar_m
arums75517833__arums
asana5315483asa_na
asanas6514113asanas
ascared10399523ascared
ascarid103910723ascarid
ascaris93613323ascaris
ascus75013583as_cus
ashrams1236653ashrams
asrama839193asrama
assume897563as_sume
assure6610773assure
astral66919283astral
astray95615543astray
asylums1243633asylums
atrium8411823atrium
aurums849383a_urums
award97118043awar_d
awards107113453awards
aware86420023awar_e
barium10313513_barium
barm86739603_bar_m
carom95025563_carom
charm126124663char_m
cuprum1236743cuprum
datum8310633_datum
disarm9310473disar_m
drum76521593__drum
durum8513203_durum
eardrum10135423eardrum
estrums9208603estrums
estrus61912113estrus
fanum10313443_fanum
farm95934533_far_m
ferrum1147453ferrum
forum108318763_forum
fusarium1344233fusarium
gaum75726423_ga_um
granum9310913granum
grum75625083__grum
hadarim13117453hadarim
harem104924453_harem
harm95637793_har_m
hassium1236133hassium
imaum9139643ima_um
inarm7314423inar_m
iterum837903iterum
jorum145513743_jorum
kashrut1444913kashrut
labarums1254503labarums
labrum1057423labrum
ladanum1045183ladanum
larums83610533_larums
lustrum945853lustrum
masurium1245893masurium
nostrum946953nostrum
oakum1177313_oakum
oestrum9177783oestrum
omasum1035503omasum
osar46820953osar__
osmium1036573osmium
ostium8310133ostium
papadum1475233papadum
plastrum1245713plastrum
psalm949273psa_lm
quorum1736023quorum
rearm75923573rear_m
rosarium10126913rosarium
rostrum947213rostrum
rum56644643___rum
sacrums11388043sacrums
samarium1257283samarium
saran53730303_saran
sard55344243_sar_d
sards64736183_sards
saree55044663_saree
sarge65531133_sarge
sargo65424413_sargo
sari45444043_sar_i
sarin55239253_sarin
saris54544953_saris
sark84938973_sar_k
sarks96632463_sarks
sarky125521783_sarky
sarod65325873_sarod
saros55238063_saros
satem76021463_satem
sau36356573_sa_u_
saul45836523_sa_ul
saury84317223_saury
scram910621623_scram
scrim95419743_scrim
scrub94914203_scrub
scrums104614253_scrums
scum85924523_s_cum
sebum93814553_sebum
sedum84115573_sedum
serums83916303_serums
shrub104814893_shrub
shrug94512513_shrug
sirup74014913_sirup
sistrum946563sistrum
slum65430513_s_lum
smarm95517603smar_m
solum74717613_solum
sorus54527583_sorus
sprue74717633_sprue
sprug85313893_sprug
struma84313273_struma
strums84716453_strums
strut56030733_strut
stum65526023_s_tum
sum56346013_s__um
swarm106218843swar_m
swum96416823_s_wum
syrup103010963_syrup
tantrum946683tantrum
tharm105916643thar_m
thrum104713633_thrum
tsar47819803tsar__
tsardom1044483tsardom
tsarism958253tsarism
tsars56717113tsar_s
unarm7314453unar_m
varus85921183_varus
warm95935673_war_m
zoarium1846093zoarium

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.390458182.1
2DLD Change Limit1127161785.01622471.3
3Display Results1781780.0463869.6
 (SQL Overall)1786911785.45232775.3
 
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.