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

123 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
aureole73869(None) 
areole61017281a_reole
aureola747031aureola
aureolae845311aureolae
aureoled945731aureoled
aureoles838281aureoles
airhole1048272airhole
areola6813672a_reola
areolae7811732a_reolae
areoles71016952a_reoles
aureate72515282aureate
aureolas846852aureolas
auricle9139812auricle
creole8913722_creole
abele76323253a_be_le
acerola947823acerola
acerose9310893acerose
acreage1037833acreage
aerobe8412403aer_obe
agree65226033agre__e
airholes1138033airholes
allele64514563alle_le
alveoli1043583alveoli
amarelle1045613amarelle
amole75724593a__mole
anele55628833a_ne_le
anisole71010833anisole
anole55330373a__nole
aquarelle1852953aquarelle
arable81821003a_rable
areae55229743a_re_ae
areal55928733a_real_
arene55329413a_re_ne
arenose7311373a_renose
areolar779223a_reolar
areolas71013863a_reolas
areolate81014453a_reolate
arete56031353a_re_te
argle65421563a_r_gle
argol65317263a_rgol_
argols74514613a_rgols
argyle1066063a_rgyle
ariose64818723a_riose
arkose104911343a_rkose
armhole1236943armhole
arose55832083a_r_ose
arugola844353arugola
asshole1046793asshole
atremble1244113atremble
auberge1045633auberge
audible10228243audible
audile73315303au_dile
aurae54128113aur__ae
aural54428963aur_al_
aurally10310533aurally
aurate64426473aur_ate
aurei54821863aure__i
aureoling1045873aureoling
aures55137093aure__s
aureus65314883aure_us
auricled11135703auricled
auricles10138333auricles
aurora6411763aur_ora
aurorae739663aurorae
aurous64119263aur_ous
azole145118033a__zole
borecole1246623borecole
borehole1347623borehole
burble104617703bur_ble
burette939853burette
burgle94815863bur_gle
cabriole1276933cabriole
capriole1276913capriole
cariole9818343cariole
carriole1089863carriole
cineole91010003cineole
creoles9913323_creoles
curable112414513curable
curdle95514313cur_dle
curette939783curette
curule83614123cur_ule
dariole8711163dariole
durable102312723durable
foveole13106873foveole
furore9410013fur_ore
gurgle83912473gur_gle
hurdle103712793hur_dle
hurtle93512943hur_tle
jurel124516333jure_l_
jurels133710583jure_ls
laureate888023laureate
laurel649033laure_l_
laureled934543laure_led
laurelled1043613laurelled
laurels746663laure_ls
morelle91210803morelle
mudhole1344913mudhole
nucleole1045053nucleole
oriole6814293_oriole
outsole71013433outsole
parole84425253par_ole
prole74527793_pr_ole
puerile9310093puerile
puree74632843pure__e
purely114013613pure_ly
purfle112511183pur_fle
purple102712673pur_ple
purpose1137383purpose
pyrrole1246033pyrrole
resole64624183__resole
role45851823__r_ole
rubeola9115123rubeola
safrole1037253safr_ole
saurel6511983saure_l_
saurels749293saure_ls
surely93816453sure_ly
treble8311663_treble
turnsole844693turnsole
turtle63213573tur_tle
ureal56722683_ureal_
urease64516993_urease
ureide7310363_ureide
variole10711593variole

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.1561145455.1
2DLD Change Limit1340271237.65617506.1
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.85822740.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.