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 “aroma” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

73 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
aroma7122014(None) 
aboma91114601aboma
aromas81018611aromas
abomas101113582abomas
acromia1139962acromia
agama85815582agama
agma77623262a_gma
agora6914332agora
alma66333022a_lma
aloha8513612aloha
ama510853302a__ma
anima74620072anima
anoa45634472ano_a
anomy105113392anomy
aorta55922572aorta
arame75026622arame
area45843392ar_ea
areca75618632areca
arena55323812arena
areola6813672areola
arepa75615562arepa
aria46245422ar_ia
arm58449622ar_m_
armor75118052armor
arms66137492ar_ms
army96624182ar_my
aroid65428342aroid
arose55832082arose
arroba898662arroba
arum66129032arum_
arums75517832arums
asrama839192asrama
atma68121772a_tma
atom67824522atom_
atoms76817562atoms
atomy107415192atomy
aurora6411762aurora
bromal10313652bromal
brome94421972brome
bromo95217202bromo
caeoma1039032caeoma
carom95025562carom_
caroms105619572caroms
chroma132912472chroma
coma87134852_coma
drama85117412drama
from96923922from_
grama85620282grama
karma113415002kar_ma
korma115913072korma
krona93611792krona
myoma1239272myoma
narcoma1145822narcoma
noma67529462_noma
prima95019342prima
proa66229962pro_a
prom87631702prom_
promo95620002promo
proms95426412proms
roam67132412_roam
rom59855632_rom_
roman75424822_roman
romp85926572_romp
roms67038962_roms
rota45834342_rota
sarcoma1147402sarcoma
soma65635292_soma
stoma75918272stoma
stroma84313072stroma
tarama8412732tarama
tromp95815802tromp
trona54118952trona
tryma1037222tryma

Search took 3 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 Filter178691538000.313570897.8
2DLD Change Limit53800731.71631352.0
3Display Results73730.0164562.5
 (SQL Overall)178691732.04587379.5
 
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.