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

111 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
triangles103574(None) 
triangle935531triangle_
triangled1143941triangled
cringles11329462cri_ngles
strangles103011552str_angles
tangles83920042t__angles
tingles83818322t_i_ngles
triages82613792tria_g_es
triazoles1844392triazoles
trindles93211682tri_ndles
twangles1245742t_wangles
wrangles1237462wr_angles
angles74426703___angles
arranges939413arrang_es
bangles103617413__bangles
brindles113710223bri_ndles
crankles143510153cr_ankles
cringes103215503cri_ng_es
cringle103010353cri_ngle_
crinkles14269163cri_nkles
dangles93618423__dangles
dingles93818323_di_ngles
draggles1145963dr_aggles
entangles1075563entangles
eringoes937433eri_ngoes
finagles12237553_finagles
fringes113514103fri_ng_es
granges93516523gr_ang_es
granules939933gr_anules
ingles74420873__i_ngles
jangles154015683__jangles
jingles153816383_ji_ngles
mangles104021463__mangles
mingles103719003_mi_ngles
octangles1243463octangles
oranges84215333or_ang_es
raggles93813283_r_aggles
ranges73826923_r_ang_es
rankles113114543_r_ankles
ringlet82818173_ri_nglet
ringlets92910233_ri_nglets
semiangles1343473semiangles
shingles123111113shi_ngles
singles83520433_si_ngles
spangles1138893_spangles
straggles11328503str_aggles
stranges94516763str_ang_es
strangle98411503str_angle_
strangled11268983str_angled
strangler10369473str_angler
stranglers11396823str_anglers
stringless1145353stri_ngless
swingles12319543swi_ngles
tangle74019953t__angle_
tangled94214633t__angled
tangler83515073t__angler
tanglers92911973t__anglers
thiazoles2142553thiazoles
tinges74722333t_i_ng_es
tingle74319063t_i_ngle_
tingled93712803t_i_ngled
tingler83613343t_i_ngler
tinglers93710593t_i_nglers
tinkles113713923t_i_nkles
trachles13311753tr_achles
trainees82712063train_ees
tramples122610203tr_amples
trances93919643tr_an_ces
tranches132915513tr_anches
trangams1147203tr_angams
trannies8415013tr_annies
treacles1039703trea_cles
treadles939703trea_dles
triable92515393tria_ble_
triage72812893tria_g_e_
triaged92810443tria_g_ed
trialogues1142893trialogues
trials64319883tria__l_s
triangular1162863triangular
triangulates1363813triangulates
triazines1847543triazines
triazole1744153triazole_
trickles143013763tri_ckles
tricycles1644363tricycles
trienes74118413trien__es
trientes82812123trien_tes
trifles103814823tri__fles
trilogies1048173trilogies
trindle83311363tri_ndle_
trindled10388693tri_ndled
trines64132563tri_n__es
triples94616873tri__ples
trisceles1145293trisceles
triskeles1344273triskeles
triunes74311383triun__es
truancies1146883truancies
trundles9278483tr_undles
twangle1145803t_wangle_
twangled1364173t_wangled
twangler1244113t_wangler
twanglers1363433t_wanglers
twinges11409453twi_ng_es
twinkles1535073twi_nkles
untangles1054713untangles
wangles113416933__wangles
wrangle1137383wr_angle_
wrangled1335593wr_angled
wrangler1245473wr_angler
wranglers1344273wr_anglers
wriggles13286263wri_ggles
wrinkles15296693wri_nkles

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411117.17020731.0
3Display Results1111110.0462413.0
 (SQL Overall)1786911117.63923391.9
 
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.