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

90 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
aureoled94574(None) 
aureole738691aureole_
aureoles838281aureoles
areole61017282a_reole_
areoles71016952a_reoles
aureola747032aureol_a
aureolae845312aureolae
aureolas846852aureolas
auricled11135702auricled
laureled934542laure_led
laurelled1043612laurelled
abseiled1144733abseiled
agreed84712503agre__ed
airhole1048273airhole_
airholes1138033airholes
aneled74719283a_ne_led
angeled93211513ange_led
annealed936343annealed
appealed1335603appealed
aproned10311503apr_oned
arbored103811603a_rbored
areola6813673a_reol_a
areolae7811733a_reolae
areolar779223a_reolar
areolas71013863a_reolas
areolated1089713a_reolated
argled85314553a_r_gled
ariled75620323a_r_iled
armored102610473a_rmored
arrested939153arrested
arrowed1148113a_rrowed
audibled12224093audibled
aurated83817793aur_ated
aureate72515283aureate_
aureoling1045873aureoling
auricle9139813auricle_
auricles10138333auricles
authored1238263authored
autoed7712823au_to_ed
barreled1137843barre_led
barrelled1245263barrelled
burbled124312673bur_bled
burgeoned1343703burgeoned
burgled115511423bur_gled
burled94825383bur__led
burrowed1444443burrowed
caprioled1464743caprioled
caroled103717693car_oled
creeled104012013_creeled
creole8913733_creole_
creoles9913323_creoles
cupeled1257793cupe_led
cupelled1365743cupelled
curdled113910663cur_dled
curetted1137173curetted
curled95021653cur__led
drooled9369203_drooled
dueled84813663du_e_led
duelled9359753du_elled
fueled104913603fu_e_led
fuelled11369193fu_elled
furled104717053fur__led
furrowed1563833furrowed
grueled937133grue_led
gruelled1034893gruelled
gurgled10399123gur_gled
hurdled12379833hur_dled
hurled104617453hur__led
hurtled11339593hur_tled
laureated1096153laureated
muraled10410833mur_aled
muralled1136423muralled
nurled74016233nur__led
paroled104217633par_oled
purebred1344253purebred
pureed95017813pure__ed
purfled13248733pur_fled
purled94520753pur__led
purpled12299783pur_pled
purposed1335263purposed
quelled17279273qu_elled
reeled74725533__reeled
reoiled84316853__reoiled
repled93319783__repled
resoled84119283__resoled
streeled9267873streeled
trebled1038483_trebled
turmoiled1242603turmoiled
turtled8309683tur_tled
unreeled91310333unreeled

Search took 10 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.436409841.7
2DLD Change Limit146162908.89316435.6
3Display Results90900.0303000.0
 (SQL Overall)178691909.35919093.0
 
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.