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 “triangulate” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

59 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
triangulate127429(None) 
triangulated1473181triangulated
triangulates1363811triangulates
strangulate1275062str_angulate
triangular1162862triangula_r
angulate9312013___angulate
cingulate12238603_ci_ngulate
granulate1059183gr_an_ulate
lingulate10368193_li_ngulate
strangulated1474033str_angulated
strangulates1384823str_angulates
translate9412273tr_an_slate
transudate1146743tr_ansudate
triangle935533triang_l__e
triangularity1761763triangularity
triangularly1661913triangularly
triangulating1562353triangulating
triangulation1452703triangulation
tribulate1148083tri__bulate
angulated1139224___angulated
angulates10310864___angulates
annulate8310924___annulate
cannulate1148634__cannulate
canulate10314554__can_ulate
coagulate1258084_coa_gulate
crenulate1167694cr_en_ulate
granulated1256944gr_an_ulated
granulates1148464gr_an_ulates
granulite1046924gr_an_ulite
gratulate1047684gr_a_tulate
insulate8312844__i_nsulate
ligulate92510254_li__gulate
lingulae9357034_li_ngula_e
pinnulate1145764_pi_nnulate
planulate1146904_plan_ulate
regulate9313024_r__egulate
reregulate11145954_reregulate
stridulate1144994stri__dulate
tabulate10310894t__a_bulate
tantalate9107374t__antalate
tarantulae1052304tarantula_e
tinplate1047744t_i_n_plate
trabeculate1552904trabeculate
translated1149294tr_an_slated
translates10411704tr_an_slates
transudates1246374tr_ansudates
triacetate1263544tria_cetate
triangled1143944triang_l_ed
triangles1035744triang_l_es
triangularities1681674triangularities
triangulations1552314triangulations
triathlete1352644tria_thlete
tribulated1345824tri__bulated
tribulates1247204tri__bulates
tribunate1144954tri__bunate
trijugate1743244tri__jugate
triturate947484tri__turate
ungulate939804___ungulate
virgulate1345234_vi_rgulate

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 Filter1786911488190.406440125.6
2DLD Change Limit148819598.20318142.0
3Display Results59590.0301966.7
 (SQL Overall)178691598.63920684.2
 
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.