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

64 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
aureolas84685(None) 
areolas71013861a_reolas
aureola747031aureola_
aureolae845311aureolae
aureoles838281aureoles
acerolas1048052acerolas
areola6813672a_reola_
areolae7811732a_reolae
areolar779222a_reolar
areoles71016952a_reoles
arugolas944402arugolas
aureole738692aureol_e
aureoled945742aureoled
auroras7311702aur_oras
rubeolas10154852rubeolas
acerola947823acerola_
adrenals946313adrenals
airholes1138033airholes
akelas10311193a_ke_las
alveolar1143293alveolar
alveolars1242603alveolars
alveolus1143023alveolus
amreetas1044273amreetas
areas55935773a_re__as
arecas84817443a_re_cas
arenas65021993a_re_nas
areolate81014453a_reolate
areole61017283a_reol_e
arepas85515703a_re_pas
argalas84011093a_rgalas
argols74514613a_rgol_s
aromas81018613a_r_omas
arrobas969213a_rrobas
arugola844353arugola_
arugulas943913arugulas
atresias839473atresias
aubretias1145033aubretias
auras55932563aur___as
aureoling1045873aureoling
aures55137093aure___s
aureus65314883aure__us
auricles10138333auricles
auriculas1146053auriculas
aurochs1245983aur_ochs
aurora6411763aur_ora_
aurorae739663aur_orae
auroral7310473aur_oral
aurous64119263aur_o_us
creoles9913323_creoles
cupolas11277753cu_polas
foveolas14135113foveolas
jurels133710583jure_l_s
laurels746663laure_l_s
pergolas1158233pergolas
pyrolas1239863pyr_olas
roseolas8107163roseolas
rubellas10136123rubellas
rubeola9115123rubeola_
rubeolar10153213rubeolar
rugolas836373ru_golas
saurels749303saure_l_s
ureas55826013_ure__as
uremias9249503_uremias
variolas1168533variolas

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 Filter1786911461620.420425454.8
2DLD Change Limit146162646.58022213.1
3Display Results64640.0302133.3
 (SQL Overall)178691647.03025418.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.