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

127 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
triptan94754(None) 
triptane1047561triptane
triptans1047361triptans
gripman1234462gripman
taipan82410662taip_an
titan53318172t_i_tan
trapan82412972trap_an
trepan82511672trep_an
triplane1039112triplane
triptanes1147462triptanes
triton63914892tri_ton
arista6415293arista_
aristae7312533aristae
aristas7413523aristas
captan101613343_captan
crista8311803crista_
cristae9310613cristae
cryptal1445683cryptal
dript86923873dript__
frypan1434543fryp_an
gripmen1235033gripmen
gript85126173gript__
krypton1643283krypton
origan7310693ori_gan
orphan1137733or_phan
preplan1149953preplan
priapean1243373priapean
pristane10310343pristane
propman1339063propman
puritan939283puri_tan
quintan16399223quintan
ratan53722663_r_atan
rattan63613603_rattan
replan83215823_replan
reptant92817073_reptant
riata54618023_riata_
riatas63915093_riatas
rictal83113183_rictal
ripen75619263_rip_en
riprap1055513_riprap
ripsaw1134283_ripsaw
ripsawn1242503_ripsawn
seitan62613233sei_tan
shipman14247133shipman
striata7379953striata_
stript85222193stript__
tailfan1044653tailfan
taipans9269553taip_ans
tampan102512323tamp_an
tarlatan845063tarlatan
tarletan845543tarletan
tarpan82814293tarp_an
tartan64217513t_artan
teopan839353teop_an
tictac1036563t_ictac
tinman82411143t_inman
tipcat10312653t_ipcat
tiptoe838283t_iptoe
tiptop1036103t_iptop
titans63414913t_i_tans
titian62512663t_itian
titman82711003t_itman
trainman1046233trainman
trapans92812463trap_ans
trappean1244393trappean
trapt76433393trapt__
trepang10257293trep_ang
trepans92311593trep_ans
triac74116373tri__ac
triad65217723tri__ad
trial54926353tri__al
triazin1638203triazin
tribal8611133tri_bal
triclad1037443triclad
tricorn937963tricorn
trictrac1244413trictrac
trigon74513103tri_gon
trigram1077763trigram
trimaran1045643trimaran
trinal6516963tri_nal
trip66830393trip___
tripack1565673tripack
tripart9311433tripart
tripe75425383trip__e
tripedal1144673tripedal
tripes85324873trip_es
triphase1346193triphase
triplanes1148803triplanes
triple84215923trip_le
tripled104113833tripled
triples94616873triples
triplet94319213triplet
triplex16447803triplex
tripling112712553tripling
triply114211023trip_ly
tripod9399853trip_od
tripodal1145143tripodal
tripods10359053tripods
tripody13395983tripody
tripoli937133tripoli
tripos84014923trip_os
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
tripping133210923tripping
trippy13457803trip_py
trips74923363trip__s
triptyca1542423triptyca
triptycas1642633triptycas
triptych1842283triptych
trishaw1344753trishaw
tristate8311033tristate
triste63818643trist_e
trite54730033tri_t_e
triter65120593tri_ter
tritone73613883tri_tone
tritons73814883tri_tons
trivia938503trivia_
trivial1038713trivial
tropin83316753trop_in
trypsin1245113trypsin
tryptic1446003tryptic
turista737443turista_
turistas846693turistas
tympan13257013tymp_an
witan83816503_wi_tan
written10336343written

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271276.09621986.1
3Display Results1271270.0462760.9
 (SQL Overall)1786911276.53227356.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.