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

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

79 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
aureola74703(None) 
areola6813671a_reola
aureolae845311aureolae
aureolas846861aureolas
aureole738691aureole
acerola947832acerola
areolae7811732a_reolae
areolar779222a_reolar
areolas71013872a_reolas
areole61017282a_reole
arugola844352arugola
aureoled945742aureoled
aureoles838282aureoles
aurora6411762aur_ora
rubeola9115122rubeola
acerolas1048053acerolas
adrenal838263adrenal
airhole1048273airhole
akela9311343a_ke_la
alveolar1143293alveolar
alveoli1043583alveoli
amreeta945163amreeta
area45843403a_re__a
areal55928743a_real_
areca75618633a_re_ca
arena55323813a_re_na
areolate81014463a_reolate
areoles71016953a_reoles
arepa75615563a_re_pa
argala74712673a_rgala
argol65317263a_rgol_
argols74514613a_rgols
aroma71220153a_r_oma
arroba898663a_rroba
arugolas944403arugolas
arugula843913arugula
atresia7310243atresia
aubretia1045283aubretia
aura45836253aur___a
aural54428963aur_al_
aurally10310543aurally
aureate72515293aureate
aurei54821863aure__i
aureoling1045873aureoling
aures55137093aure__s
aureus65314883aure_us
auricle9139813auricle
auricula1045803auricula
aurorae739663aur_orae
auroral7310473aur_oral
auroras7311703aur_oras
aurous64119263aur_ous
creole8913733_creole
cupola10317693cu_pola
curiosa9346643curiosa
eureka1034483eure_ka
foveola13115013foveola
furcula1245803furcula
hordeola1244733hordeola
jurel124516333jure_l_
jurels133710583jure_ls
laurel649033laure_l_
laurels746663laure_ls
pergola1067623pergola
purely114013633pure_ly
pyrola1139003pyr_ola
roseola777053roseola
rubella9146523rubella
rubeolar10153223rubeolar
rubeolas10154853rubeolas
rugola736293ru_gola
saurel6511993saure_l_
saurels749303saure_ls
surely93816463sure_ly
urea46528063_ure__a
ureal56722683_ureal_
uredia73610063_uredia
uremia82910893_uremia
variola1068893variola

Search took 8 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.406440125.6
2DLD Change Limit134027796.68620045.9
3Display Results79790.0332393.9
 (SQL Overall)178691797.12525079.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.