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

110 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
triangle93553(None) 
triangled1143941triangled
triangles1035741triangles
cringle103010352cri_ngle
strangle98411502str_angle
tangle74019952t__angle
tingle74319062t_i_ngle
triable92515392tria_ble
triage72812892tria_g_e
triazole1744152triazole
trindle83311362tri_ndle
twangle1145802t_wangle
wrangle1137382wr_angle
angle64528873___angle
arrange838683arrang_e
atingle848253ati_ngle
bangle94018953__bangle
brindle104210103bri_ndle
crankle133610063cr_ankle
cringe93515483cri_ng_e
cringles11329463cri_ngles
crinkle13359413cri_nkle
dangle84119303__dangle
dingle84317073_di_ngle
draggle1056103dr_aggle
entangle966253entangle
finagle11238313_finagle
friable122612563fria_ble
fringe104013953fri_ng_e
grange83716203gr_ang_e
granule839473gr_anule
ingle64120433__i_ngle
jangle144416293__jangle
jingle143815223_ji_ngle
mangle93921323__mangle
mingle93518783_mi_ngle
octangle1143833octangle
orange74016323or_ang_e
raggle83712883_r_aggle
range64728413_r_ang_e
rankle103414883_r_ankle
riantly1037613_riantly
ringlet82818173_ri_nglet
semiangle1243963semiangle
shingle117711283shi_ngle
single74520603_si_ngle
spangle1038403_spangle
straggle10359133str_aggle
strange85416343str_ang_e
strangled11268983str_angled
strangler10369473str_angler
strangles103011553str_angles
swingle113510563swi_ngle
tangled94214633t__angled
tangler83515073t__angler
tangles83920043t__angles
tangly104413913t__angly
thiazole2042883thiazole
tinge64626623t_i_ng_e
tingled93712803t_i_ngled
tingler83613343t_i_ngler
tingles83818323t_i_ngles
tingly103815973t_i_ngly
tinkle103714453t_i_nkle
trachle12311853tr_achle
trainable1138943trainable
trainee72817793train_ee
trample11299703tr_ample
trance84718763tr_an_ce
tranche123312223tr_anche
trangam1039353tr_angam
treacle939973trea_cle
treadle8310103trea_dle
triaged92810443tria_ged
triages82613793tria_ges
trial54926353tria__l_
trialogue1042743trialogue
trials64319883tria__ls
triangular1162863triangular
triangulate1274293triangulate
triazine1738503triazine
triazoles1844393triazoles
trickle133613443tri_ckle
tricycle1543893tricycle
triene64316383trien__e
trifle94012883tri__fle
trigly103810943tri__gly
trinal6516963tri_nal_
trindled10388693tri_ndled
trindles93211683tri_ndles
trine54734603tri_n__e
triple84215923tri__ple
triscele1045433triscele
triskele1244573triskele
triune64210183triun__e
truantly1144643truantly
trundle8307873tr_undle
tryingly1535883tryingly
twangled1364173t_wangled
twangler1244113t_wangler
twangles1245743t_wangles
twinge104210403twi_ng_e
twinkle1464773twi_nkle
untangle966323untangle
wangle103817503__wangle
wrangled1335593wr_angled
wrangler1245473wr_angler
wrangles1237463wr_angles
wriggle12316213wri_ggle
wrinkle14296923wri_nkle

Search took 7 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 Limit1461621106.39022873.6
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.84226116.8
 
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.