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

348 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
tranches13291551(None) 
branches153613801branches
cranches153114541cranches
ranches123620111_ranches
trances93919641tranc_es
tranche123312221tranche_
trenches133512601trenches
blanches153311602blanches
braches144621222bra_ches
branched163210452branched
brunches153710452brunches
cranched163210412cranched
cratches153012542cratches
craunches1655722craunches
crunches153711352crunches
drenches14309802drenches
frenches163311632frenches
grinches1436952grinches
manches143818622_manches
oraches124216472ora_ches
planches153111862planches
prances113618772pranc_es
rances84625442_ranc_es
ranched133113602_ranched
rancher123013632_rancher
ranchers133311792_ranchers
ranchos123911392_ranchos
ratches123620462_ratches
raunches1368052_raunches
stanches132312792stanches
taches114224172t_a_ches
teaches122718352tea_ches
tenches123515522t_enches
thatches1637512thatches
traces85329932tra_c_es
trachea12311682tra_chea
tracheas13410272tra_cheas
trachles13311752tra_chles
trance84718762tranc_e_
tranced104414172tranc_ed
trannies8415012trannies
trashes104119262tra_shes
trauchles1445492trauchles
trenched14289852trenched
trencher13279312trencher
trenchers14288072trenchers
troches123715342tr_oches
truancies1146882truancies
wrenches163210232wrenches
aches106132293__a_ches
anchos114214893__anchos
apaches143411843apa_ches
arches114822043__arches
attaches13137723atta_ches
baches135426943_ba_ches
batches144019613_batches
beaches144120653bea_ches
benches143918603_benches
blanched16308603blanched
blancher15338633blancher
blanchers16307433blanchers
blenches153310763blenches
braces108427773bra_c_es
brachet144020313bra_chet
brachets154311983bra_chets
brachs134415753bra_ch_s
branch134014773branch__
branchia15217713branchia
branchier1637133branchier
branchiest1746713branchiest
branchless1743303branchless
branchlet1647183branchlet
branchlets1743803branchlets
branchy17357913branch_y
brandies11714563brandies
brashes124518463bra_shes
breaches153714123breaches
breeches15258673breeches
brioches15227253brioches
britches15278683britches
broaches153211623broaches
bronchos15206173bronchos
bronchus15204743bronchus
brooches15288193brooches
brunched16317853brunched
bruncher15347783bruncher
brunchers16296253brunchers
bunches144116033_bunches
caches137926913_ca_ches
canchas143212403_canchas
caroches15710693caroches
catches144320773_catches
chances145218093chanc_es
chancres15429363chancres
chinches18369363chinches
cinches144215773_cinches
clenches152910953clenches
clinches153910363clinches
coaches144018693coa_ches
conches144019813_conches
cranch133613533cranch__
cranes84330753cran__es
crankles143510153crankles
crannies10313013crannies
crashes124618403cra_shes
craunched1764023craunched
creches14313093cr_eches
crotches153411303crotches
crouches153711293crouches
crunched16328163crunched
cruncher15338073cruncher
crunchers16316243crunchers
crutches15359593crutches
dances95120653_danc_es
drachms1534253dra_chms
drenched15247913drenched
drencher14257213drencher
drenchers15296103drenchers
dunches133312583_dunches
durances1158683duranc_es
earaches13411313earaches
entrances11310953entranc_es
entrenches1545213entrenches
errancies1147963errancies
fancies124018783_fancies
fiancees1335103fiancees
fiances12310673fianc_es
finches153914193_finches
flenches163410533flenches
flinches16358953flinches
franchise1746003franchise
franchises1855633franchises
francizes2346793francizes
francs114112193franc__s
frenched17299433frenched
ganaches1437433_ganaches
glances104113143glanc_es
glunches1436263glunches
graces94523493gra_c_es
grandees103211283grandees
granges93516523gran_ges
granites92116363granites
grannies9312613grannies
grantees92510973grantees
granules939933granules
grouches14328213grouches
grutches14285853grutches
hances115621283_hanc_es
hatches153420273_hatches
haunches1656963haunches
hunches153913463_hunches
inarches1358043inarches
inches114419673__inches
intrenches1545813intrenches
iterances1148913iteranc_es
kenches163912273_kenches
klatches17157143klatches
laches116528353_la_ches
lances84824103_lanc_es
larches124416453_larches
latches123320133_latches
launches1387903launches
leaches123319343lea_ches
loaches123613983loa_ches
lunches124115443_lunches
lynches15378873_lynches
maches134827233_ma_ches
manche133515103_manche_
manchet143317783_manchet
manchets15269573_manchets
marches143921173_marches
matches143219783_matches
munches144215793_munches
naches114622413_na_ches
nances83618643_nanc_es
nancies93516843_nancies
nuances938523nuanc_es
orache114013593ora_che_
oracles93212423ora_cles
oranges84215333oran_ges
outrances112912113outranc_es
painches1588913painches
panaches15310293_panaches
panoches1548123_panoches
parches143720003_parches
patches143320383_patches
paunches1568173paunches
peaches144120053pea_ches
pinches144117933_pinches
planche14299753planche_
planchet152511963planchet
planchets16236743planchets
plenches153110623plenches
poaches144416943poa_ches
prance104318573pranc_e_
pranced123714043pranc_ed
prancer113613383pranc_er
prancers123210333prancers
preaches153214893preaches
princes113015143princ_es
punches144816133_punches
quaiches2235343quaiches
quenches2236013quenches
races74943243_ra_c_es
rachet115028973_ra_chet
rachets124516833_ra_chets
rachis114017653_ra_chis
rance75028513_ranc_e_
ranch105019793_ranch__
ranchero13277423_ranchero
rancheros14255793_rancheros
ranchless1444453_ranchless
ranchmen1545833_ranchmen
rancho114310853_ranch_o
rancors9811373_rancors
randies84225663_randies
ranees64623963_ran_ees
ranges73826933_ran_ges
rankles113114543_rankles
raphes115117453_ra_phes
rashes95330153_ra_shes
ratchet124218333_ratchet
ratchets133110263_ratchets
reaches123423203_reaches
rebranches1745193rebranches
retches123318513_retches
retrenches1545903retrenches
revanches1746253revanches
riches115022083_r_iches
roaches123616213_roaches
rotches123515703_rotches
rouches124217893_rouches
ruches114819583_r_uches
scratches1647323scratches
scrunches1635403scrunches
seances93015343seanc_es
searches132112903searches
slatches131511533slatches
snatches131410713snatches
stances93715963stanc_es
stanched14208903stanched
stancher13198813stancher
stanchers14206813stanchers
stanchest14218213stanchest
starches131912913starches
staunches1444603staunches
stenches132110293stenches
stranges94516763stran_ges
strangles103011553strangles
stretches1438293stretches
swatches16169963swatches
taces76237803t_a_c_es
tache106222373t_a_che_
tachs105820933t_a_ch_s
takahes1436173t_akahes
tangles83920053t_angles
tansies74521243t_ansies
tarnishes12188893tarnishes
teacher123714833tea_cher
teachers133212393tea_chers
tenaces92814513tenac_es
tenancies1149173tenancies
thanages12107623thanages
thanes94918983than__es
thatched1735433thatched
thatcher1635663thatcher
thatchers1744583thatchers
thrashes1487653thra_shes
torches123715443t_orches
touches125118343t_ouches
trace75829613tra_c_e_
traced94821583tra_c_ed
tracer84820233tra_c_er
tracers94917843tra_cers
tracheae1349113tra_cheae
tracheal1348253tra_cheal
tracheid1437583tra_cheid
tracheids1545053tra_cheids
trachle12311853tra_chle
trachled1438313tra_chled
trachytes1745923tra_chytes
tracked143716133tra_cked
tracker133515173tra_cker
trackers143512853tra_ckers
tracks124818843tra_c_ks
tracts85019073tra_c_ts
trades75724503tra__des
traduces1136563traduces
trainees82712063trainees
traipses1036873traipses
tramcars1245233tramcars
tramples122610203tramples
trancing112812023trancing
trangams1147203trangams
tranks104017763tran__ks
tranqs155210313tran__qs
trans54933043tran___s
transfer1138433transfer
transfers1238053transfers
tranship13410193tranship
tranships14410333tranships
transits8313503transits
transoms1048933transoms
transudes1047593transudes
trapes85024463tra__pes
trapeses1039153trapeses
trapezes1936543trapezes
trashed113514703tra_shed
trasher104416133tra_sher
trashers113013643tra_shers
trasses74819323tra_sses
trauchle1344963trauchle
trauchled1543733trauchled
traves94222743tra__ves
treacles1039703treacles
trench114211613trench__
trendies9312213trendies
triangles1035743triangles
triarchies1544553triarchies
trices84826333tr_ic_es
trindles93211683trindles
trines64132563trin__es
troche113112513tr_oche_
trochee122613883tr_ochee
trochees132510183tr_ochees
trones65629283tron__es
trounces1037063trounc_es
truces84916333tr_uc_es
truncates1145843truncates
truncheon1442833truncheon
truncheons1542423truncheons
trundles9278483trundles
tusches1237903t_usches
twangles1245743twangles
twankies1535893twankies
twitches16156373twitches
tyrannies1255533tyrannies
uranides92211283uranides
uranites82514643uranites
usances967373usanc_es
watches153017373_watches
wenches152914133_wenches
winches154714373_winches
wrangles1237463wrangles
wrenched17748133wrenched
wrencher16287783wrencher
wrenchers17256333wrenchers
wretches16257283wretches

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.423422437.4
2DLD Change Limit1461623487.71618942.7
3Display Results3483480.1432433.6
 (SQL Overall)1786913488.28221575.8
 
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.