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

112 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
aureoles83828(None) 
areoles71016951a_reoles
aureolas846851aureolas
aureole738691aureole_
aureoled945741aureoled
airholes1138032airholes
areolas71013862a_reolas
areole61017282a_reole_
aureola747032aureol_a
aureolae845312aureolae
auricles10138332auricles
creoles9913322_creoles
abeles84719393a_be_les
acerolas1048053acerolas
acreages1138373acreages
aerobes9311493aer_obes
agrees74915323agre__es
airhole1048273airhole_
alleles73812033alle_les
alveolus1143023alveolus
amarelles1145533amarelles
amoles84122193a__moles
aneles64626293a_ne_les
anisoles81010123anisoles
anoles64827433a__noles
anureses837973anure_ses
aquarelles1952853aquarelles
arables91814973a_rables
arbores94016033a_rbores
arenes64928393a_re_nes
areola6813673a_reol_a
areolae7811733a_reolae
areolar779223a_reolar
aretes64425353a_re_tes
argles75218483a_r_gles
argols74514613a_rgol_s
argyles1136053a_rgyles
arkoses113910833a_rkoses
arles56735743a_r__les
armholes1347383armholes
arugolas944403arugolas
assholes1146743assholes
auberges1146673auberges
audibles11215533audibles
audiles83112613au_diles
aureate72515283aureate_
aureoling1045873aureoling
aures55137093aur___es
aureus65314883aure__us
auricle9139813auricle_
auricled11135703auricled
aurochs1245983aur_ochs
auroras7311703aur_oras
aurous64119263aur_o_us
auxeses1435623auxe_ses
azoles154614613a__zoles
borecoles1345973borecoles
boreholes1447353boreholes
burbles114916803bur_bles
burettes1048953burettes
burgles105615963bur_gles
cabrioles1376363cabrioles
caprioles1376753caprioles
carioles10817073carioles
carrioles1169473carrioles
cineoles10109403cineoles
creole8913733_creole_
curdles103814573cur_dles
cureless10319703cure_less
curettes1039313curettes
darioles9710693darioles
durables11237013durables
duresses939173duresses
duxelles1643963duxelles
foveoles1496643foveoles
furores10310033fur_ores
gurgles94312873gur_gles
hurdles113613373hur_dles
hurtles103913753hur_tles
jurels133710583jure_l_s
kurtoses12105623kurtoses
laureates987683laureates
laureled934543laure_led
laurelled1043613laurelled
laurels746663laure_l_s
lurexes1436073lure_xes
morelles10710493morelles
mudholes1444873mudholes
murexes1636973mure_xes
nucleoles1145263nucleoles
orioles7412993_orioles
outsoles8813113outsoles
paroles95025883par_oles
proles84627203_pr_oles
purees84721683pure__es
purfles122511843pur_fles
purples112712833pur_ples
purposes1237823purposes
pyrroles1345453pyrroles
reales64934123__reales
resoles73823653__resoles
roles56747983__r_oles
rubeolas10154853rubeolas
safroles1136933safr_oles
saurels749303saure_l_s
sureties8316583sureties
trebles9311443_trebles
turnsoles944203turnsoles
turtles72914343tur_tles
ureases74416723_ureases
ureides8311103_ureides
varioles11711123varioles

Search took 9 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.406440125.6
2DLD Change Limit1461621127.82618676.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.27821586.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.