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

94 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
triptans104736(None) 
triptan947541triptan_
triptane1047561triptane
triptanes1147461triptanes
taipans9269552taip_ans
titans63414912t_i_tans
trapans92812462trap_ans
trepans92311592trep_ans
triplane1039112triplane
triplanes1148802triplanes
tritons73814882tri_tons
aristas7413523arista_s
captans111612053_captans
frypans1544053fryp_ans
gripman1234463gripman_
kryptons1743223kryptons
origans839973ori_gans
orphans1237773or_phans
preplans1249613preplans
pristane10310343pristane
pristanes11410433pristanes
puritans1037633puri_tans
quintans17337873quintans
ratans63819373_r_atans
rattans73411953_rattans
replans92814943_replans
reptant92817073_reptant
riatas63915093_riata_s
ripens85012173_rip_ens
ripraps1134943_ripraps
ripsaws1243823_ripsaws
seitans73312303sei_tans
tailfans1144553tailfans
taipan82410663taip_an_
tampans113310983tamp_ans
tarlatans944353tarlatans
tarletans944653tarletans
tarpans92513533tarp_ans
tartans72615823t_artans
teopans939203teop_ans
tictacs1145793t_ictacs
tipcats1137103t_ipcats
tiptoes939173t_iptoes
tiptops1136073t_iptops
titan53318173t_i_tan_
titians72710453t_itians
trans54933043tr___ans
trapan82412973trap_an_
trepan82511673trep_an_
trepang10257293trep_ang
trepangs11205403trep_angs
triacs83913223tri__acs
triads74513533tri__ads
trials64319883tri__als
triazins1738353triazins
tribals9610753tri_bals
triclads1146233triclads
tricorns1036683tricorns
trictracs1344043trictracs
triens65417543tri__ens
trigons84312093tri_gons
trigrams11116353trigrams
trimarans1144693trimarans
tripack1565673trip_ack
tripacks1664893tripacks
tripart9311433trip_art
tripes85324873trip__es
triphase1346193triphase
triples94616873trip_les
triplets103510263triplets
tripling112712553tripling
tripods10359053trip_ods
tripolis1038713tripolis
tripos84014923trip__os
triposes1039973triposes
trippers123210163trippers
trippets12357423trippets
tripping133210923tripping
trippings14225723trippings
trips74923363trip___s
triptyca1542423triptyca
triptycas1642633triptycas
triptych1842283triptych
triptychs1952063triptychs
trishaws1444003trishaws
tristate8311033tristate
triton63914893tri_ton_
tritone73613883tri_tone
tritones83413443tri_tones
tropins93116313trop_ins
trypsins1344903trypsins
turistas846693turista_s
tympans14236813tymp_ans
witans93412933_wi_tans

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 Filter1786911461620.436409841.7
2DLD Change Limit146162947.51619446.8
3Display Results94940.0332848.5
 (SQL Overall)178691947.98522378.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.