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

129 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
tribades113689(None) 
tribade1037291tribade_
brigades1236392brigades
tirades8311722t_irades
trades75724502tr__ades
triads74513532tri_ad_s
triages82613792tri_ages
tribadic1344102tribadic
tribadism1444152tribadism
tribals9610752triba_ls
tribes85119022trib__es
tribunes1055852tribunes
tributes1047232tributes
triodes84012502tri_odes
alidades1037003alidades
arcades101113193ar_cades
aubades1038753_aubades
bribees11409283brib_ees
bribes105918533brib__es
brides94423513bri__des
brigade1136493brigade_
brigaded1344573brigaded
brocades1358713brocades
cribbages1642763cribbages
crusades1146333crusades
dribbles13348393dribbles
dryades12395633dr_yades
fribbles15287713fribbles
frigates12310933frigates
gambades1435863gambades
grades84926313gr__ades
grenades1038433grenades
gribbles13307363gribbles
grides84422363gri__des
grillades1194543grillades
grimaces1355383grimaces
irades74517393__irades
irides74519123iri__des
marinades12268973marinades
naiades838213nai_ades
prebade12310283prebade_
prebakes1639013prebakes
prefades1439533prefades
prides94324183pri__des
primages13159273primages
primates121515933primates
privates131812373privates
probates12414283probates
rebates95123183_rebates
ribalds10236673_ribalds
ribands10208393_ribands
ribes75530173_rib__es
riboses9310443_riboses
rides66140813_ri__des
rivages1138873_rivages
rubaces1139313_rubaces
striates83417083stri_ates
strides84520393stri__des
tides64830153t_i__des
tildes74513963t_i_ldes
timbales12227843timbales
tirade7311693t_irade_
tisanes7311853t_isanes
torsades937213torsades
traces85329933tr__aces
trade65026043tr__ade_
traded85717683tr__aded
trader75218763tr__ader
traders84316953tr__aders
trapes85024463tr__apes
traves94222743tr__aves
treaded95014283tr_eaded
treader84113833tr_eader
treaders93311843tr_eaders
treadles939703tr_eadles
treads74817923tr_ead_s
trebles9311443treb_les
triable92515393triable_
triacs83913223tri_a_cs
triad65217723tri_ad__
triadic1037833tri_adic
triadics1146133tri_adics
triadism1147553tri_adism
triage72812893tri_age_
triaged92810443tri_aged
trials64319883tri_a_ls
tribadisms1543533tribadisms
tribal8611133triba__l
tribalism1347893tribalism
tribalist1149953tribalist
tribally1347323tribally
tribasic1244793tribasic
tribe74420273trib__e_
tribrachs1643173tribrachs
tribulates1247203tribulates
tribunates1244173tribunates
tribune945573tribune_
tribute937313tribute_
trices84826333tri__ces
trickles143013763trickles
triclads1146233triclad_s
trienes74118413tri_enes
trientes82812123trientes
tries55742813tri___es
trifles103814823tri_fles
trikes105419493tri__kes
trilbies1037693trilbies
trindles93211683trindles
trines64132563tri__nes
triode75311893tri_ode_
trioses75015653tri_oses
trioxides1744483trioxides
tripacks1664893tripacks
tripes85324873tri__pes
triplanes1148803triplanes
triples94616873tri_ples
tripodies1246573tripodies
tripods10359053tripod_s
triposes1039973triposes
triptanes1147463triptanes
triremes1035523triremes
trisemes1036643trisemes
trisomes1039833trisomes
tritones83413443tritones
triunes74311383tri_unes
trivalves1544143trivalves
tsades74310993t__sades
tziganes1853023tziganes
urinates8314133urinates

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621296.44022696.0
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.92225814.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.