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

61 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
triptanes114746(None) 
triplanes1148801triplanes
triptane1047561triptane_
triptans1047361triptan_s
pristanes11410432pristanes
triplane1039112triplane_
triptan947542triptan__
tritones83413442tri_tones
airplanes1187233airplanes
biplanes1238573_biplanes
driftages1453153driftages
dripstones1343933dripstones
heptanes1339003_heptanes
pristane10310343pristane_
propanes122415823prop_anes
riptides1136413_riptides
skiplanes1544633skiplanes
stripteases1352683stripteases
tailplanes1244313tailplanes
taipans9269553taip_an_s
tipstaves1443353t_ipstaves
tiptoes939173t_ipt_oes
tisanes7311853t_i_sanes
titaness836723t_i_taness
titans63414913t_i_tan_s
towplanes1444683towplanes
tractates1159763tractates
trapans92812463trap_an_s
traplines11310373traplines
trepangs11205403trep_angs
trepans92311593trep_an_s
trephines1448483trephines
triages82613793tri__ages
triazines1847543triazines
tribades1136893tri_bades
tribunes1055853tri_bunes
tricornes1146233tricornes
tricotines1247453tricotines
trienes74118413tri__enes
trines64132563tri___nes
tripacks1664893trip_acks
tripes85324873trip___es
triphase1346193triphase_
triples94616873trip__les
triplexes1844253triplexes
triplites1148283triplites
tripodies1246573tripodies
triposes1039973trip_oses
trippings14225723trippings
triptycas1642633triptycas
triptychs1952063triptychs
tripwires1443283tripwires
tristate8311033tristate_
triteness9310363tri_teness
tritone73613883tri_tone_
tritons73814883tri_ton_s
triunes74311383tri__unes
tropines102214923trop_ines
tropotaxes1953833tropotaxes
tryptamines1852993tryptamines
tziganes1853023tzi_ganes

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.420425454.8
2DLD Change Limit148641617.34620234.3
3Display Results61610.0134692.3
 (SQL Overall)178691617.77922970.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.