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

128 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
tripart931143(None) 
tipcart1148832t_ipcart
trinary1039172trinary
tripack1565672tripack
triplet94319212triplet
trippet113714112trippet
airpark1344923airpark
airport9511383airport
apart74330673__apart
ariary94114203ari_ary
biparty1445583_biparty
briar75718153bri_ar_
briard94311293bri_ard
briars84814823bri_ars
briary114912003bri_ary
brisant9312683brisant
compart134016003compart
depart94720563_depart
dispart101115283dispart
dript86923873drip__t
forepart1349703forepart
friar85414273fri_ar_
friars93812093fri_ars
friary124010093fri_ary
griper94114613griper_
gripers104011463gripers
gript85126173grip__t
impart102715143_impart
mispart111113783mispart
ovipara1242543ovipara
part65967463___part
prepare111913623prepare
primary1437703primary
rampart11311993rampart
repark123511713_repark
repast83520633_repast
report85326023_report
riant55833153_ri_ant
riper74328403_riper_
ripest84317943_ripest
ripost83615003_ripost
riprap1055513_riprap
ritard74812083_ritard
striper94514793striper_
stripers103911593stripers
stript85222193strip__t
subpart11311123subpart
taipan82410663taipa_n
taipans9269553taipans
tart47566183t___art
teacart91113193teacart
thrawart1445163thrawart
thwart12311683t_hwart
tiara5315913t_i_ara
tipcarts1244573t_ipcarts
tipcat10312653t_ipcat
tippet103917873t_ippet
topiary1245813topiary
tract75635713tr__act
trait56940843tr__ait
trapan82412973trapa_n
trapans92812463trapans
trapt76433393tr__apt
treat56240353tr_ea_t
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
triac74116373tri_a_c
triacs83913223tri_acs
triad65217723tri_a_d
triads74513533tri_ads
triage72812893tri_age
trial54926353tri_a_l
trials64319883tri_als
tribade1037293tribade
tribal8611133triba_l
tribals9610753tribals
tricorn937963tricorn
tricot8317753tri_cot
trident8314193trident
trier54328533tri_er_
triers64321523tri_ers
triform1237853triform
trigram1077763trigram
trijet133916553tri_jet
trimaran1045643trimaran
trimer85717153trimer_
trimers94615143trimers
trinal6516963trina_l
trinket11314813trinket
triolet73219523triolet
trip66830393trip___
tripacks1664893tripacks
tripartite1253233tripartite
tripe75425383trip__e
tripes85324873trip_es
triphase1346193triphase
triplane1039113triplane
triple84215923trip_le
tripled104113833tripled
triples94616873triples
triplets103510263triplets
triplex16447803triplex
triplite1039103triplite
triply114211023trip_ly
tripod9399853trip_od
tripods10359053tripods
tripody13395983tripody
tripoli937133tripoli
tripos84014923trip_os
tripped123911693tripped
tripper113711923tripper
trippers123210163trippers
trippets12357423trippets
trippy13457803trip_py
trips74923363trip__s
triptan947543triptan
triptane1047563triptane
triptans1047363triptans
tripwire1343603tripwire
trisect939733trisect
triter65120593triter_
tritest7315273tritest
trivet93721883tri_vet
trocar848773trocar_
trocars959043trocars
truant6315783tr_uant
urinary1037243urinary

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.406440125.6
2DLD Change Limit1340271285.93622578.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.38827972.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.